formula help
 

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

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

formula help
 

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

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

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




--
Barny

formula help
 

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
"John" wrote in message
...
Hi Barny
Try this =IF(O19="Y",N19,IF(O19="N",0,IF(O19="","")))
HTH
John
"Barny" wrote in message
...

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

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




--
Barny

formula help
 

"Barny" wrote:
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 -----

"Barny" wrote in message
...

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

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




--
Barny