Calculating percentage values for positive and negative values

**dotsofcolor** · 01-03-2012, 12:25 PM

I looked through the forum and tried some examples none seem to fit what I was looking for, so I apologize in advance if I missed it.

I need to calculate the percentage difference between negative and positive values. I tried a few options with ABS, etc. but didn't get what I was looking for.

I want the percetage to calculate properly and show as a postive value. Like the formula that I tried on the first row displayed as -100.00%. I would like it to show as 100.00% without the negative sign.

Also in cell row 7 I have several instances where I need to calulate the $ difference but to show as a positive value in column D ($ Difference cell) I would also like all the values in Column D to reflect postive values if possible.

I have attached some sample data so that you can see what I need. I appreciate your help.

**Andrew-R** · 01-03-2012, 12:32 PM

Unless I'm missing something I think the formula for column D is:

=ABS(A2-B2)

And for column E it's:

=ABS(D2/A2)

But you'll need to format col E as percentage.

**dotsofcolor** · 01-03-2012, 01:57 PM

Perfect thanks, and it helped me get to my next step in the sheet. I was over thinking it on the ABS. Excellent help Andrew, I really appreciate it.

**dotsofcolor** · 01-03-2012, 05:56 PM

I thought that this was solved on my end but came up with this.

Is there a way to work in an IF statement with the ABS function that if the value in the cell in empty, basically zero can it put in a specific value say 100.00%?

I would like the percentage to show as 100.00% if there is no value present to divide. Hope that makes sense.