IF function

C

cant_remember

Hi All-

it's been so long since I've used excel I'm having problems rememberin
how to use the functions.

I need to know how to set up a worksheet so that if I enter any numbe
in one cell it will automatically mulitiply that number by 15 and plac
the answer in another cell.

Any direction would be greatly appreciated!
Thank you
 
K

kk

Hi,

Example:

Value enter in A2 and want the answer display in B2...

Formula in B2, type in =A2*15




"cant_remember" <[email protected]>
wrote in message

Hi All-

it's been so long since I've used excel I'm having problems remembering
how to use the functions.

I need to know how to set up a worksheet so that if I enter any number
in one cell it will automatically mulitiply that number by 15 and place
the answer in another cell.

Any direction would be greatly appreciated!
Thank you!
 
G

GeorgeF

If cell A1 is the location of incoming number, then the calculatio
cell, B1 (or any other cell of choice) would read
=15*A1
George
 
C

cant_remember

Thanks kk and George F!

I'm not sure why I was thinking I needed the IF! Silly me! :confused


Appreciate your help
 
Top