excell formula can any one help

[Guest]

Take an example of d7 is 25 kg now in cell g 7 I create the formula =f7/40
this returns 0.625 how do I get this to round up to and show 1.00 in cell f7

Hope you can help

 

[Guest]

there are two ways you can do this,right click on the cell and format /number
/decimal places to 0.This will round up or down depending on wether above or
below .5.If you always want to round up then in cell f7
=roundup(d7/40,0).Bear in mind in subsequent calculations the actual value
will be used,ie .625 not 1

 

[Guest]

Your question is very confusing.

What has the 25kg in D7 got to do with the formula?

for the formula in G7 (F7/40) to = 0.625 then F7 must contain 25 yet in your
question you want the to =1

If you want then F7/40 to return 1 then use =ceiling(F7/40)

Mike

 

[Dave Peterson]

Just to add to Paul's response.

If you format the cell to show 0 decimals, then the value will still be 0.625.
And this may not round up the way you want (like Paul wrote).

If you use =roundup(d7/40,0), the value will be 1.