Percentage Calculation
\1
I believe my comment in the picture (see link above) explains what I am trying to accomplish. Basically, If column A is a number greater than 0 AND column B is equal to 0, column D should display 100%, otherwise it should divide column C by column B.
at the same time though,
If both column A and column B both equal 0, column D should display a blank cell because you can't divide by 0's it'll throw an error.
Thanks for the help!
Try:
=IF(A3+B3=0,"",IF(AND(A3>0,B3=0),100,C3/B3))
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.
perfect NBVC! I just got some more information about this though....
If column C is a negative change, I need the percentage to display as a negative percentage. If column C is a positive change, I need the percentage to display as a positive percentage.
Do I just make the "100" a "-100"?
Last edited by NBVC; 09-16-2008 at 02:54 PM. Reason: Fixed message formatting
Does this only apply when A3>0 and B3=0?
If so, try:
=IF(A3+B3=0,"",IF(AND(A3>0,B3=0),IF(C3>0,100,-100),C3/B3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks