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