1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with a function in Excel

Discussion in 'Software' started by asymvivastos, Oct 17, 2007.

  1. asymvivastos

    asymvivastos New Member

    4
    0
    6
    Hello ppl and sorry if this isn't the right subforum to post my question.:rolleyes:

    But let me explain what I want to do.I have an excel sheet in which in column "D" I am going to add various values (for example 10,16,80,100 etc).I want to know if its possible to multiply those values with a specific number (12 particularly) and excel display straight away the result.

    Every help will be much appreciated!!! :D
     
  2. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    Hi

    don't you just type =d1*12 in whatever box you want the answer to appear in or am I being to simplistic?
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  3. asymvivastos

    asymvivastos New Member

    4
    0
    6
    greenbrucelee I probably didn't explain very well what I want.
    I was wondering if the result could be displayed in the same cell that I enter each value.
     
  4. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    As long as it is in another cell then that would work, if you put that formula in the d1 cell it would mean it would loop, Excel throws an error when you try to do this.
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  5. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    I am sure there is a way but can't think of it right now, I haven't used excel properly for years/
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  6. asymvivastos

    asymvivastos New Member

    4
    0
    6
    That error I want to overcome because I want to use the same cell.
     
  7. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    If I remember rightly it something to with putting the formula in the cells you are going to put the numbers into and making the formula stick, sort of like a macro then when you put your numbers in it calculates the results.

    I just can't seem to think of what it is :blink
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  8. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    A small vb script would do this in a macro. 8)
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  9. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    asymvivastos,

    An Excel cell can hold:
    1. Data
    2. Formula

    You can't hold both in the same cell.
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  10. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    asymvivastos,

    Why do you need to use the same cell?
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  11. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    thats the one :)

    rep given as you have reminded me of how I did it at Uni.
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  12. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    Sparky,

    Would that vb script be able to distinguish between pre-processed data and post-processed data?
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  13. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    if all he wants is whatever the numbers entered into the cell to multiply by 12 then why not?

    I am sure thats the way I did it at Uni.
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  14. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    greenbrucelee,

    I was just curious from a data integrity perspective of accidentally re-running the script on the post-processed data so instead of the original number times 12, it'll be the original number times 144 or higher.
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  15. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    The macro may have to be executed manually however it could be coded to 'remember' what cells have already been processed. This can just be a true\false value in a column which could be hidden.
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  16. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    yep I know what you mean it can happen as the integers could loop it happened to me before, the script would have to identify each cell so that didn't happen.
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  17. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    Sparky,

    If we're going to use another column but hidden, then wouldn't it be easier to just create another column that holds the formula to multiply by 12? :p
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  18. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    Sorry to interrupt when you are asking Sparky but the poster wanted the same column/cell so when he enters 80 into say d1 it multiplys by 12
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  19. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    LOL! I guess you could! :biggrin
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  20. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,191
    299
    319
    Good point! 8)
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010

Share This Page

Loading...