problem with true/false statements

[paul thomas]

Hi there

trying to do a formula based on true/false output but I cant get round this

Team A(B1) v(D1)Team B

IF SUM(B1>D1) say 1 - 0 {if true = 1 if false = 0}
IF SUM(B1<D1) say 0 - 1 {if true = 1 if false = 0}

No problem threre.. BUT

IF SUM (B1=D1) say 0 -0 or 1 -1 {if true = 1 if false =0}OK but
the trouble is if blank in both cells still shows 1 I need it to show 0
false
basically if b1=" " and D1=" " then false = 0

Please help I can't solve it - pulling my hair out what little I have left.

Cheers
Paul

 

[Andy Brown]

IF SUM(B1>D1) say 1 - 0 {if true = 1 if false = 0}

Lose the SUM ; =IF(B1>D1 ... will do.

basically if b1=" " and D1=" " then false = 0

=IF(AND(B1="",D1=""),0)

, or use a formula to this effect in Conditional Formatting.

Rgds,
Andy

 

[paul thomas]

Hi Andy

Thanks for your asistance

The following formula did want i required
=(B1>=D1)*(B1<>"")*(D1<>"")

Thankyou for your help!

Cheers Paul