IF function

  • Thread starter Thread starter cant_remember
  • Start date Start date
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
 
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!
 
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
 
Thanks kk and George F!

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


Appreciate your help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to set up a simple variable in Excel, but cell location independent 3
Editing an "IF" function across a worksheet/excel file 2
IF function says too many nested 1
Excel VBA 1
Combining Macros and if function 2
IF AND Nested Functions - Formula Not Working 0
Excel Excel IF variable based on time of day 0
This function returns incorrect value sporadically 1

Back
Top