formula help

[Barny]

Help please - I would like to return a value in cell D13 based on th
following-

IF O19 = Y then D13 = value in cell N19
Or IF O19 = N then D13 = zero
Or If O19 = blank then D13 = zer

 

[John]

Hi Barny
Try this =IF(O19="Y",N19,IF(O19="N",0,IF(O19="","")))
HTH
John

 

[John]

Mistake
If you O19 is Blank return 0
=IF(O19="Y",N19,IF(O19="N",0,IF(O19="",0)))
That should do it
Regards
John

 

[Joe User]

IF O19 = Y then D13 = value in cell N19
Or IF O19 = N then D13 = zero
Or If O19 = blank then D13 = zero

If O19 will only contain Y, N or blank, or if want everything else to be
treated that same as "N", then:

=if(O19="Y", N19, 0)

Otherwise, to do exactly as you wrote it:

=if(O19="Y", N19, if(OR(O19={"N",""}),"","4th case!"))

You need to replace "4th case!" with whatever you want when O19 is not "Y",
"N" or blank.


----- original message -----