Calculating percentage values for positive and negative values

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.