Greetings! I have the following formula that calculates the percentage change:
=IF((B2+C2)=0,0,IF(B2=0,"100%",(C2-B2)/B2))
Is there a way to edit the formula to also include the outcome if the result is less than 1% to display "<1%" instead of, for example, 0.04%?
Thanks!
Last edited by temple1; 01-10-2012 at 12:47 PM.
=IF((B2+C2)=0,0,IF(B2=0,"100%",IF((C2-B2)/B2)<1%,"<1%",(C2-B2)/B2)))
Regards, TMS
Thank u for a quick reply TMSchucks. Pretty straight forward formula and I actually tried that myself as well, but for some strange reason I'm getting an error message and it's pointing to B2 in here ,IF((C2-B2)/B2)<1%,
Apologies, my fault, not tested.
=IF((B2+C2)=0,0,IF(B2=0,"100%",IF((C2-B2)/B2<1%,"<1%",(C2-B2)/B2)))
Regards, TMS
Re: Percent calculation formula
Thanks for getting me on the right track. I added more statements to cover less than -1% as well. Again, thank u!
=IF((B69+C69)=0,0,IF(B69=0,"100%",IF(AND((C69-B69)/B69<1%,(C69-B69)/B69>0%),"<1%",IF(AND((C69-B69)/B69<0%,(C69-B69)/B69>-1%),"<-1%",(C69-B69)/B69))))
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks