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