Two different results from the same figures

[mrcois]

I have one block that genereates a result from preceeding formulas, and another block that generates a result from setout numbers.

The problem I have is that all figures are the same but the results are different? I want to know why?

PLEASE see attached file as example...

[NBVC]

It is because of the precision level...the results of I4 and I5 are actually to many decimal places.. where the numbers in L4 and L5 are precisely to 1 decimal place.

[mrcois]

Thanks for the help... Is there a way to return a result with 2 or 4 decimal places?

[NBVC]

To get same result:

=(1-ROUND(I5,1))*ROUND(I4,1)/ROUND(I5,1)

[mrcois]

Brilliant, it works 100%.. Thanks..