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))



Rich wrote:

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.
--
Rich

"Rich" wrote:

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

Thanks for the help,
--
Rich

--

Dave Peterson