Sanjay has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel formula for Complete number
Hi,
I have a query which need a formula.
so suppose we have any of the number and when we divide that number with 39 and if we got a result like x.01 to x.99 , result will come in next column x+1.
lets take a example
suppose we have numbers 80 and 115, when we divide these 2 numbers from 39 the result would be .
80/39=2.05
115/39=2.94
but in the column the result should take the next complete number for both condition. that means 3 in both of the condition.
Please let me know if you need any more information on it.
Thanks
Sanjay
RE: Excel formula for Complete number
Hi Sanjay,
Thank you for the contextual information
It sounds like you need a ROUNDUP formula
If A1 is 80 then the formula in B1 would be
=ROUNDUP(A1/39,)
This will round up to 0 decimal places, you might need to change the formatting.
I hope that helps
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
