Rounding numbers in formula

[Greyowlsl]

Hi,

I have a cell that has a formula (lets say the result number of the formula is 50.5)

The actual number in the cell is however is shown as 51 (due to cell formating)

Now my problem is that the next cell formula requires whole numbers to work.

So my question is what do i put in my formula if i want to use the another cells rounded cell result rather than that cells actuall formula result.

Thanks.
Greyowl

 

[pbaldy]

Have you tried the Round() function?