If Formula

[Hoopsah]

Hi

Trying to write a formula that would calculate:

If D5 = 0 then 0 else B5-D5, If B5=0 then 0 else B5 - D5

if(D5=0,0,(B5-D5),if(B5=0,0,B5-D5))

Can't get it to work properly

Any help would be appreciated.

 

[excelpunk]

Try this
=if(or(D5=0,B5=0),0,(B5-D5))

 

[Jugantarji]

You could try

=IF(OR(B5=0,D5=0),0,(B5-D5))

 

[Hoopsah]

Thanks guys,

Works perfectly

Cheers

Hoopsah