Dealing with minus numbers in formulas

  • Thread starter Thread starter duubgina
  • Start date Start date
D

duubgina

I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64) .
The value in cell C63 is calculated by a formula =SUM(C62*0.4) which can
sometimes produce a minus figure. When the figure in C63 is a minus
number, I want it to show a 0, so that the minus number is not factored
in to the sum of cells C61,C63,C64. Hope that makes sense! Any
suggestions gratefully received! (e-mail address removed)
 
In progress

I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64)
The value in cell C63 is calculated by a formula =SUM(C62*0.4) which
can sometimes produce a minus figure. When the figure in C63 is a minus
number, I want it to show a 0, so that the minus number is not factored
in to the sum of cells C61,C63,C64. Hope that makes sense! Any
suggestions gratefully received! (e-mail address removed)

Replace
=SUM(C61,C63,C64)
with
=SUM(C61,C63*(C63>0),C64)
 
In C63 use one of
(a) =IF(C62<0,0,C62*0.4)
or (b) =(C62*0.4)*(C62>0)
For the summation use =C61+C63+C64
No need to clutter cells with SUM every time you code a simple formula
best wishes
 
Back
Top