Percent displaying wrong.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a formula to calculate service level percentage. The answer
displays as 1082% and should be 82%

Thanks for the help,
 
What's the formula?
What are the values that the formula uses?
What is the numberformat for that cell?
 
The part of your message where you told us what your formula was, and what
values were in the cells to which the formula refers, seems to have got lost
in transit?
 
The formula is
=IF(ISERROR((B15+B18)-(B16+B18)/(B15+B18)=TRUE),"",(B15+B18)-(B16+B18)/(B15+B18))
Values are B15 = 10
B16 = 1
B18 = 1
Number format is percent with no decimal.
 
You need a couple of extra parenthesis and also there is no need to use TRUE

=IF(ISERROR(((B15+B18)-(B16+B18))/(B15+B18)),"",((B15+B18)-(B16+B18))/(B15+B18))
 
I think you had a couple of parens in the wrong spots:

=IF(ISERROR((B15+B18)-(B16+B18)/(B15+B18))=TRUE,"",
((B15+B18)-(B16+B18))/(B15+B18))

or
=IF(ISERROR(((B15+B18)-(B16+B18))/(B15+B18)),"",((B15+B18)-(B16+B18))/(B15+B18))

===
But you could bet simplify that first expression--you're adding B18, then
subtracting B18.


=IF(ISERROR((B15-B16)/(B15+B18)),"",((B15-B16))/(B15+B18))
 
Back
Top