sum question

[punter]

Hi,

I'm having an issue getting a formula to work. I want to subtract I3
from E3. If that is anything besides zero I then want to subtract the
sum of N3 and O3 from the total of I3-E3. I'm going through my books
and the help topics but cant get it to work. Here is the formula I
have in there now: =sum(E3-I3)-sum(N3:03). I only want it to
subtract the second part of the formula if the first part (E3-I3) is
anything but 0.

Any thoughts?

Thanks

Eddie

 

[Alan]

=IF(I3-E3<>0,SUM(N3,O3)-SUM(E3,E3),0)
Regards,
Alan.

 

[Bernard Liengme]

First of all let's clear up SUM. You generally use this for something like
=SUM(A1:A10); this sums A1+A2,+A3....+a10
But =SUM(E3-I3) while not wrong, is unnecessary; just use =E3-I3.
And SUM(N3:O3) is better written as =N3+O3 in most cases

Your problem is solved with =IF(E3-I3<>0, E3-I3-(N3+O3),0)
I assume you want zero when (E3_I3) is zero
best wishes

 

[punter]

Thank you both so much. You saved me much time.

Eddie

 

[Bob Phillips]

If you want 0 even if I3>e3 then

=MAX(E3-I3-(N3+O3),0)

otherwise

=E3-I3-(N3+O3)*(E3-I3>0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)