If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula help
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|