| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminate Negatives
This formula (= B2 B3) is in cell B5. I want to modify (= B2 B3) so that
if the answer is a negative number a 0 will appear in cell B5 instead of a negative number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Eliminate Negatives
=MAX(0,B2-B3)
"MCheru" wrote in message ... This formula (= B2 - B3) is in cell B5. I want to modify (= B2 - B3) so that if the answer is a negative number a "0" will appear in cell B5 instead of a negative number. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Eliminate Negatives
Thank you. This is good!
"Bob Umlas" wrote: =MAX(0,B2-B3) "MCheru" wrote in message ... This formula (= B2 - B3) is in cell B5. I want to modify (= B2 - B3) so that if the answer is a negative number a "0" will appear in cell B5 instead of a negative number. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Eliminate Negatives
Hi,
You can also try the follwing: =if(B2-B3<0,0,B2-B3) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MCheru" wrote in message ... This formula (= B2 B3) is in cell B5. I want to modify (= B2 B3) so that if the answer is a negative number a 0 will appear in cell B5 instead of a negative number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minimum without zeros or negatives | Excel Worksheet Functions | |||
| Help, my columns are negatives! -- bug? | Charts and Charting in Excel | |||
| How do I use Excel with times which are negatives? | Excel Discussion (Misc queries) | |||
| Positives and Negatives | Excel Worksheet Functions | |||
| multiply negatives | Excel Discussion (Misc queries) | |||
Linear Mode
