Hi everyone!
I am calculating percentage change with formula: =(IFERROR((D6-C6)/C6;0%)), which results any error to be shown as 0%.
My problem:
How could I integrate IF formula with IFERROR, so that if everytime the result is 100%, the result would still show 0%. Or is there another formula I could use?
Thanks alot,
Marty
Last edited by NBVC; 08-31-2011 at 10:43 AM.
Do you only want to do that if the result is exactly 100%, what if it's 101%...or 200% or 300%?
Audere est facere
Try:
=IF(ISERROR((D6-C6)/C6);0%;IF((D6-C6)/C6=100%;0%;(D6-C6)/C6))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
@Daddylonglegs:
Yeah, only if the result is 100,00%
Last edited by Domyzon; 08-31-2011 at 10:18 AM.
@NBVC:
It doesn't seem to work, still shows 100%.
Did you check if the result of (D6-C6)/C6 is exactly 100% (i.e. is it formatted to show no decimals)?
@NBVC:
Oh, it was -100% I noticed. Thanks alot for your help
Case solved
You should only get 100% if D6 is exactly double C6 therefore
=IFERROR(IF(D6/C6=2;0;D6/C6-1);0)
Advance button wont work when editing the first post. Cant change it to solved...
I did it for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks