If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|