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. |
All times are GMT +1. The time now is 08:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com