excell formula can any one help
 

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

excell formula can any one help
 

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

excell formula can any one 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

excell formula can any one 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