| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
