Excel formula for Complete number

Resolved · Urgent Priority · Version 2010

Mon 13 Nov 2017, 14:48 Delegate Sanjay said...

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

Tue 14 Nov 2017, 11:28 Trainer Richard said...

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

Tue 14 Nov 2017, 19:17 Delegate Sanjay said...

RE: Excel formula for Complete number

Thanks Richard.

its working.

Thanks
Sanjay

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips