Round numbers

[Chi]

Hi,

I am using the formula below to calculate the TotalCorrect. It works fine.
However, answer is not rounded.

=1-([TotalError]/[TotalAudit])

I would like to have the results like the examples below.

Ex: 75.24% will be 75 since # 2 is less than 5
And 28.60% will be 29 since #6 is bigger than 5.

Please help

 

[Allen Browne]

Try:
=Round(1 - ([TotalError]/[TotalAudit]), 2)

Or even better:
=IIf([TotalAudit] = 0, Null, Round(1 - ([TotalError]/[TotalAudit]), 2))

 

[Chi]

Thank you very much! It works perfectly!!

Chi

Try:
=Round(1 - ([TotalError]/[TotalAudit]), 2)

Or even better:
=IIf([TotalAudit] = 0, Null, Round(1 - ([TotalError]/[TotalAudit]), 2))

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am using the formula below to calculate the TotalCorrect. It works fine.
However, answer is not rounded.

=1-([TotalError]/[TotalAudit])

I would like to have the results like the examples below.

Ex: 75.24% will be 75 since # 2 is less than 5
And 28.60% will be 29 since #6 is bigger than 5.