Formula

Please help with the following formula

If C26<0 AND D26 >0 then E6 = 0 (the result must return 0 not true or false)
If C26>0 AND D26 <0 then E6 = 0
If C26>0 AND D26 >0 then E6 = c26 less d26

Many Thanks

Hi

Try this formula in cell E6

=IF(AND(C26<0,D26>0),IF(AND(C26>0,D26<0),0,0),IF(AND(C26>0,D26>0),C26-D26,0))

works a treat - many thanks