if then else if nested functions in excel
Hi,
Maybe this
=IF(H8=0,"",IF(D8="y",H8-(H8*O8),IF(D8="n",H8,"Unspecified")))
Mike
"vik" wrote:
I need code to give the following result: (I've tried and failed, tho I think
I'm close)
if A=0 then " "
else if B="Y" then (H8-(H8*O8))
else if B="N" then H8
here's what I have now:
=IF(H8=0," ",(IF D8="Y",(H8-(H8*O8)),(IF D8="N",H8)))
|