IF function
 

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!


--
cant_remember
------------------------------------------------------------------------
cant_remember's Profile: http://www.excelforum.com/member.php...o&userid=26833
View this thread: http://www.excelforum.com/showthread...hreadid=400813

Hi,

Example:

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

Formula in B2, type in =A2*15




"cant_remember"
wrote in message
news:cant_remember.1umz2g_1125504341.7778@excelfor um-nospam.com...

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!


--
cant_remember
------------------------------------------------------------------------
cant_remember's Profile:
http://www.excelforum.com/member.php...o&userid=26833
View this thread: http://www.excelforum.com/showthread...hreadid=400813

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


--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=400813

Thanks kk and George F!

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


Appreciate your help!


--
cant_remember
------------------------------------------------------------------------
cant_remember's Profile: http://www.excelforum.com/member.php...o&userid=26833
View this thread: http://www.excelforum.com/showthread...hreadid=400813