Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Negative Numbers to Zero
I've been searching around and can't seem to figure out how to write a
formula that will round a negative number to 0 correctly. I used the (MAX(0,A1) and it seemed to work from that cell but another cell pulls the value from that cell and it was still using the negative number to calculate. I need a formula that will round the negative number to Zero and then use the Zero from that roundup when other cells are referring to it. Does that make sense? Need help!! Thanks, Robbie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to the nearest 25 including negative numbers?? | Excel Discussion (Misc queries) | |||
Rounding to the nearest 25 including negative numbers?? | Excel Discussion (Misc queries) | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
Rounding formulas for negative numbers | Excel Worksheet Functions |