Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Roundup
Hi,
Try this, Suppose A1=14.30,then put B1=Int(A1,1)+if(mod(A1,1)<=.29,0,1) Thank you, K.S.warrier "Hakan D" wrote: I want to use roundup formula in a few different rows in a worksheet, anything above .30 will be round up to next nearest number such as 14.30 will appear as 15 whilst 14.29 will appear as 14. (Decimal places will be 0)Is this possible ? Can I put this formula in format/cell or Do I have to use different rows ? your help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I roundup to the nearest 9 | New Users to Excel | |||
How can I roundup to next 0 i.e. 71 to 80? | Excel Worksheet Functions |