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 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.
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.
From your given data, your formula would beOriginally Posted by Linds
=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
Houston, TX
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
>
>
Linds
See answers to your earlier post.
Gord
On Wed, 21 Dec 2005 09:31:02 -0800, "Linds" <[email protected]>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks