Formatting negative numbers to equal zero

  • Thread starter Thread starter kjhxsh
  • Start date Start date
K

kjhxsh

Is it possible to conditionally format a cell so that if it's formula equals
a number less than zero that it displays as zero?
 
Yes.

Let's say you gave the number 5 in cell A1 and the number 6 in cell B1.
Your formula is in cell C1, =A1-B1 with gives you -1. If you wrap that
formula in an If statement, you can force it to zero:
=IF(A1-B1<0,0,A1-B1)

You are simply saying that if the difference between A1 and B1 is less than
zero, evaluate as zero, otherwise give the positive difference.
 
Hi

You don't need conditional formatting.

Select the cell(s) and goto Format > Cells > Number > Category: Custom >
Type: Enter #0_),[Red]"0"

Hopes this helps
 
Try this formula =MAX(0,your formula)

examples

rather than =A1-B1 or =A1*-(0.10/12)

try use =MAX(0,A1-B1) or =MAX(0,A1*-(0.10/12))
 
Back
Top