April 8, 2025 Menu
» » How to change negative number into zero using Max formula in Ms Excel

A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
Below you can find two columns with numbers. To subtract the numbers in column B from the numbers in column A, execute the following steps.
1. Select cell C1.
2. Enter the formula =A1-B1
3. Click the lower right corner of cell C1 and drag the formula down.
 
Result:


4. To change the negative numbers to zero but leave the positive numbers unchanged, instead of =A1-B1, use =MAX(0,A1-B1) and drag the function down.
Result:
12 Sep 2014
Labels:
at 10:15

0 comments:

Post a Comment

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.

Subscribe to: Post Comments (Atom)
 
Top