If/Then help needed

  • Thread starter Thread starter RGT
  • Start date Start date
R

RGT

I need to have a cell do the following

if sum is less than zero show sum as zero, else show answer of zero or
greater.

Thanks,
Russ
 
Russ,

=MAX(SUM(Whatever), 0)

or

IF(SUM(Whatever)>0, SUM(Whatever), 0)

You can also simply show negative sums as zero with a number format code,
such as:

General;0;0
0.0;0;0
 
Back
Top