blank display if figures not yet entered

**1.zer0** · 06-19-2009, 04:39 AM

I have this formula in a cell:

=IF(AND($D4=H4,$F4=I4),3,IF(SIGN($D4-$F4)=SIGN(H4-I4),1,0))

but i need to somehow incorporate a formula that only shows this if a cell has a value present.

I know as an example its something like:

=IF(C2="","",C3)

but i dont know how that would go in my existing formula as i dont know how to stack IF statements?? (a very kind person on this forum did the original formula btw)

the cell that i need to have as the 'blank or not' is D4.

Many Thanks

**zbor** · 06-19-2009, 04:43 AM

Do opposite:

IF(C2=something; C3; "")

Edit : Or this

IF(D4="";"";IF(AND($D4=H4,$F4=I4),3,IF(SIGN($D4-$F4)=SIGN(H4-I4),1,0)))

**1.zer0** · 06-19-2009, 04:53 AM

exceptional zbor. Thank you very much.

IIRC it was you who did the original formula, no?

Such a great, friendly forum, with absolutely rapid responses. helped me immensly.

Thanks.

**zbor** · 06-19-2009, 04:58 AM

Yes, now I remember

**JediMaster** · 06-13-2010, 03:26 PM

This is my formula that you zbor must take full credit for really however the following formula does not keep the cell blank until a score is entered I have tried to follow steps above but I must be doing something wrong the formula is in cell H4

=IF(AND(D3=F3,E3=G3),3,IF(SIGN(D3-E3)=SIGN(F3-G3),1,0))

any help much appreciated

thanks

**JediMaster** · 06-13-2010, 04:05 PM

this formula:

=IF(AND(D3=F3,E3=G3),3,IF(SIGN(D3-E3)=SIGN(F3-G3),1,0))

is in cell H4 but when no value is added in D3 E3 F3 G3 3 is awareded also in the same instance if there is a value in D3 and E3 but not in F3 and G3 then a false value is calculated in H4 which I would prefer to be blank for example