Trunc Function not performing

The formula in cell AF5 will return a value of 1, as it should, but the same formula doesn't return the correct answer (should be '1') in cells AF6 and AF10?

many thanks!

Hi

That is because the values in AE6 and AE10 are less than the value in AE4. So the function result is 0.??? and when you remove the decimal part (with TRUNC), you get 0.

Try looking at ROUND, or ROUNDUP or something like that if you think the result should be 1 for those cells.


rylo

Thank you so much - I knew it was something glaringly simple.

<Bows to the master>