Help with Rounding Up Formula

[LEO-DEVIL]

i be really apricate for your help let me tell you
for example
1 bottle is 75ml
1 bottle is 24 shots

1 divided by 24 = 0.0416666666666667

i need formula 0.0416666666666667 consider as 1

if i am type 0.0833333333333333 it will automatic comes in answer 2
please help with this i trying to find alot unable to get my answer

[FDibbins]

Administrative Note:

Welcome to the forum.

For future reference, your thread title does not really convey what your request is about.

Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly.

Maybe something like this?
=ROUNDUP(A1/(1/24),1)
where your value is entered into A1.

[sktneer]

Not sure exactly what you are trying to achieve but assuming your decimal number is in A2, you may try this...

Please Login or Register  to view this content.

[LEO-DEVIL]

i am really sorry i will take care for in future

and thank you so much i waste my 5 hours to keep findind this formula now its workess thankyou soooo much

Administrative Note:

Welcome to the forum.

For future reference, your thread title does not really convey what your request is about.

Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

#1[/COLOR][/url] about proper thread titles and adjust accordingl.

Maybe something like this?
=ROUNDUP(A1/(1/24),1)
where your value is entered into A1.

[FDibbins]

Happy to help