I need for a value to appear in a cell.
 

I have one cell that I need to type in one of two letters and have the next
cell equal a monetary value. How can I do this? For example, if they type
in A I need it to be $19. If I type in B I need it to read $33.

I need for a value to appear in a cell.
 

Type the letter in A1 and in B11 put the formula:

=IF(A1="A",19,if(A1="B",33,"")) and format B1 as currency
--
Gary''s Student


"Linds" wrote:

I have one cell that I need to type in one of two letters and have the next
cell equal a monetary value. How can I do this? For example, if they type
in A I need it to be $19. If I type in B I need it to read $33.

I need for a value to appear in a cell.
 

Linds Wrote:
I have one cell that I need to type in one of two letters and have the
next
cell equal a monetary value. How can I do this? For example, if they
type
in A I need it to be $19. If I type in B I need it to read $33.

From your given data, your formula would be

=IF(A1=\"A\",19,IF(A1=\"B\",33,\"\"))

The above formula will return a blank if your entry is neither "A" nor
"B" ... hope this helps you.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=495247

I need for a value to appear in a cell.
 

Note: Don't type the slashes "\" that appear in the formula below.

"BenjieLop" wrote:


Linds Wrote:
I have one cell that I need to type in one of two letters and have the
next
cell equal a monetary value. How can I do this? For example, if they
type
in A I need it to be $19. If I type in B I need it to read $33.

From your given data, your formula would be

=IF(A1=\"A\",19,IF(A1=\"B\",33,\"\"))

The above formula will return a blank if your entry is neither "A" nor
"B" ... hope this helps you.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=495247

I need for a value to appear in a cell.
 

Linds

See answers to your earlier post.


Gord

On Wed, 21 Dec 2005 09:31:02 -0800, "Linds"
wrote:

I have one cell that I need to type in one of two letters and have the next
cell equal a monetary value. How can I do this? For example, if they type
in A I need it to be $19. If I type in B I need it to read $33.