Round numbers

  • Thread starter Thread starter Chi
  • Start date Start date
C

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
 
Try:
=Round(1 - ([TotalError]/[TotalAudit]), 2)

Or even better:
=IIf([TotalAudit] = 0, Null, Round(1 - ([TotalError]/[TotalAudit]), 2))
 
Thank you very much! It works perfectly!!

Chi

Allen Browne said:
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.

Chi said:
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.
Click to expand...
Click to expand...
 
Back
Top