Percent displaying wrong.
I am using a formula to calculate service level percentage. The answer
displays as 1082% and should be 82% Thanks for the help, -- Rich |
Percent displaying wrong.
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 |
Percent displaying wrong.
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 |
Percent displaying wrong.
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 |
Percent displaying wrong.
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 |
Percent displaying wrong.
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 |
Percent displaying wrong.
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 |
All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com