# Solved nested if statement problem, if blank then 0 or blank

November 18, 2012 at 12:00:31
Specs: Windows XP
 I am working with a nested statement - if n2=y, then apply this and if n2=n apply this, but there will be some cells in the n column that will be blank and I can't seem to figure out how to get them to return either a blank or a zero. Any help is appreciated.

See More: nested if statement problem, if blank then 0 or blank

#1
November 18, 2012 at 13:43:09
 Try these:=IF(N2="y",1,IF(N2="n",2,0)) for a Zero=IF(N2="y",1,IF(N2="n",2,"")) for a BlankMIKEhttp://www.skeptic.com/

Report •

#2
November 18, 2012 at 16:01:39
 Looked promising for a moment, however I couldn't get it to workHere is what I am working on. I don't have a lot of skill in excel, just cobbled together so it might not be the prettiest string:=IF(E2="y",LOOKUP(D2,ALyesRate)*(G2/1000),IF(E2="n",LOOKUP(D2,ALnonRate)*(G2/1000))) So I need it to return a 0 or blank if E2 is blank

Report •

#3
November 18, 2012 at 18:33:01