Multiple IF statements plus ignoring blanks

Hi Guys,

I was wondering if someone could help me with the following problem as i have tried multiple things and i still can get it to work!

Ok i have two columns one which contains predicted values (Column C) and one with observed values (Column B). The values will either be 1 or 0.

so here is my criteria (i have used row 2 as an example):
if B2=C2, "correct"
if B2>C2, "High Predicted as low"
if B2<C2, "Low predicted as high"
IF(OR(B2,C2=" "," "))

The problem i have is that on some occasions the values in B OR C could be blank so this means my IF statement does not work as if for example B2=1 and C was blank then it would give me "high predicted as low" when in fact it should be blank as C2 is blank. This is visa vera if C2 was 1 and B2 was blank as it would give me low predicted as high when infact it should be blank! I have tried multiple if statements and have tried to include AND/OR statements too but i cant seem to get it right!

If anyone could make any suggestions it would be much appreciated

Thank you for your time





[CODE]=IF(B30>C30,"High predicted as low",(IF(B30<C30, "Low predicted as high","Correct"))) /code

Hey Tigeravatar,

Thats works! Thank you so much

dnewby