Truncate results of a formula

[PHnew]

=(F16+I16)/4

The formula above is a calculation that gives me the number of months to use in an additional calculation after adding to cells at contain a number representing "weeks."

In this case:

F16 =34
I16 = 4

38/4 = 9.5

In the result cell, I have elected to show 0 decimals, therefore the result you see is 10

However, I another cell,I am needing to use the result to calculate cost. It seems to be using 9.5 rather than 10 in the calculation.

I suppose the answer is to truncate the 9.5 so it forces a 10 to be used in the next step.

Is there a way to add truncate to the formula above so my result = 10?

 

[Jonmo1]

Truncate would result in 9, not 10

Try ROUND

=ROUND((F16+I16)/4,0)

 

[Chris Mack]

=ROUND((F16+I16)/4,0)

Hope this helps,

Chris.

 

[PHnew]

Thank you....Over complicating the simple! I appreciate the help.

 

[Jonmo1]

You're welcome.