Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
I am looking for a way to round up a number if the decimal number is greater
than .25. I looked at the ROUND and CEILING functions but can't seem to put a IF THEN statement on it. For example: 2.25 would round down to 2 2.26 would round up to 3 2.31 would round up to 3 2.15 would round down to 2. Any help would be greatly appreciated. Aaron |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
Try this:
=ROUND(A1+0.249999,0) and copy down, assuming your data starts in A1. Hope this helps. Pete On Nov 13, 2:53*pm, "Aaron" wrote: I am looking for a way to round up a number if the decimal number is greater than .25. I looked at the ROUND and CEILING functions but can't seem to put a IF THEN statement on it. For example: 2.25 would round down to 2 2.26 would round up to 3 2.31 would round up to 3 2.15 would round down to 2. Any help would be greatly appreciated. Aaron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
Perfect. Works like a charm. Thank you
Aaron "Pete_UK" wrote in message ... Try this: =ROUND(A1+0.249999,0) and copy down, assuming your data starts in A1. Hope this helps. Pete On Nov 13, 2:53 pm, "Aaron" wrote: I am looking for a way to round up a number if the decimal number is greater than .25. I looked at the ROUND and CEILING functions but can't seem to put a IF THEN statement on it. For example: 2.25 would round down to 2 2.26 would round up to 3 2.31 would round up to 3 2.15 would round down to 2. Any help would be greatly appreciated. Aaron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
You're welcome - thanks for feeding back.
Pete On Nov 13, 4:18*pm, "Aaron" wrote: Perfect. Works like a charm. Thank you Aaron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|