Thread: formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default 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