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

Thanks for the help,
--
Rich

What's the formula?
What are the values that the formula uses?
What is the numberformat for that cell?

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

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?
--
David Biddulph

"Rich" .(donotspam) wrote in message
...
I am using a formula to calculate service level percentage. The answer
displays as 1082% and should be 82%

Thanks for the help,
--
Rich

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

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



--
Regards,

Peo Sjoblom


"Rich" .(donotspam) wrote in message
...
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

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

Works great, thank you both for your help!
--
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