Hi,
I feel incredibly stupid and need help in a hurry.
I cant attach a workbook right now. Very simple problem though (I think)
Cell B1 value=4 (Total number of telephone calls)
Cell C1 value=2 (Total number of telephone calls not meeting a certain criteria)
I want Cell A1 to say 50%, meaning what % did not meet criteria. I keep getting the #value error when the cells do not have a value entered in them, and I don't want that to show.
Sorry for being so brief. Thanks!!
Last edited by tapsmiled; 12-07-2013 at 05:30 PM.
Hi,
=IFERROR(C1/B1,"")
formatted as a %. Although I can't get a #Value error only a #DIV/0! error
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks, but I dont want any error message.
Right now, I have =SUM(IFERROR(E25/C25,0)) which gives me a result of 20% (with C25=5 and E25=1). If the 2 fields are empty, it shows 0%, which is fine but it is giving me 20% rather than 80%. Im certain this is an easy fix and I am being foolish here.
I received a #value error my first time through, probably when I had empty cells. I conditional formatted the empty cells to be zero. I should have pointed that out. Sorry.
=iferror(1-e25/c25,0)
Last edited by martindwilson; 12-07-2013 at 06:02 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Awesome! That did it! Thank you so much for your help!
i changed it so its right you dont need sum
=iferror(1-e25/c25,0)
or
=iferror(1-e25/c25,"")
Hi,
If you make a post with references like B1 & C1 then you should expect a response which uses these and not different cells which you happen to tell us about after a later post.
You should be consistent or we all waste our time.
Thank you for your advice. As you are working to resolve it, so am I, and I found it more prudent to copy the point that I was at rather than going back and changing values. My initial post was in its simplest form.
If I wanted to calculate the total performance in terms of percentage (D71), what formula could I use? I attempted the following:Originally Posted by martindwilson
=SUM(IFERROR(1-(E25:F32,E42:F49,E59:F66)/(C25:C32,C42:C49,C59:D66),0))
but it I was getting a result of 0....I'm assuming because all of the empty cells were showing as 0.00%.
[ATTACH]282524[/ATTACH}
=IFERROR(1-sum(E25:F32,E42:F49,E59:F66)/sum(C25:C32,C42:C49,C59:D66),0))
I think that did it. You are great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks