IF function

[cant_remember]

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!

[GeorgeF]

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

[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
news:[email protected]...

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

[cant_remember]

Thanks kk and George F!

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

Appreciate your help!

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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

[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
news:[email protected]...

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