Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MROUND on a negative number.
I came up with the following formula all by myself !!
=IF($I$2="NOT TRANSFERRED",$K$21+$K$22,MROUND($K$21+$K$22-$K$23-$K$24,0.25)) Which will successfully (If $I$2 = "TRANSFERRED") round a decimal number to the nearest quarter. If however, the decimal number is negative, I get the NUM error. Please can you help me get it to return a negative rounded number. E.g. K21 = 17.00 K22 = 0 K23 = 0 K24 = 1.28 Therefore correct at 15.75 but if K21 = 0 K22 = 0 K23 = 0.6 K24 = 0 I would like the result to be -0.5. Your help is and always has been very much appreciated. Thanking you in anticipation. -- Big Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
### when the number is NOT negative? | Excel Worksheet Functions | |||
How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |