formula help

B

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
 
J

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
 
J

Joe User

Barny said:
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 -----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top