if then else if nested functions in excel
 

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)))

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)))