Excel formula
 

If I have a cell with Y and anothe with N and need to do a formula to say if
it is Y then that cell s/b $200.00 but if that cell is N then that cell s/b
$0.00 how do I create such a formula?
--
Kay

Excel formula
 

You state you have two cells...............one with Y and one with N

Then you refer to "it" and "that cell" which would be one cell only, not
two.

Where do you want 200 or 0 to appear based on what value?

Can you give us actual cell references?


Gord Dibben MS Excel MVP

On Sun, 5 Oct 2008 07:10:01 -0700, Kay
wrote:

If I have a cell with Y and anothe with N and need to do a formula to say if
it is Y then that cell s/b $200.00 but if that cell is N then that cell s/b
$0.00 how do I create such a formula?

Excel formula
 

If I have a cell with Y and anothe with N and need to do a formula to
say if it is Y then that cell s/b $200.00 but if that cell is N then
that cell s/b $0.00 how do I create such a formula?

This tests test A1 for Y or N, returning 200 or 0:
=CHOOSE(FIND(A1,"YN"),200,0)
Format as desired.

To provide for a different value in A1 by error, one might expand this to:
=IF(ISERROR(FIND(A1,"YN")),"Should be Y or N",
CHOOSE(FIND(A1,"YN"),200,0))