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

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
--
paul

remove nospam for email addy!



"TheHilife" wrote:

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

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.



paul wrote:

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
--
paul

remove nospam for email addy!

"TheHilife" wrote:

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


--

Dave Peterson

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

"TheHilife" wrote:

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