Formula for Budget vs Actual vs Difference

[nothere1]

I need to figure out what formula can be used to calculate the difference between the budget vs actual.
What I want to happen is, when I put in the "Actual" number value, it will then in the 3rd column (+ / -) populate as either with a red negative value or a green positive value.

For example, the first line in the picture looks correct, and I used this formula below:

=IF(C3>D3,(-(C3-D3)),(-(D3-C3)))

However, the last line in the picture I used this formula, but didn't get the desired results. The fourth line should show a positive 100 instead of a -100.

=IF(C6>D6,(-(C6-D6)),(-(D6-C6)))

Thank you,

 

[sandy666]

what condition?
and expected result

 

[Miki]

I think the question I have is similar to this topic, so I'll leave it here.
What I have is a calculation of Committed and Actual to show the difference and then to show that difference in %.
Further, the % should max out at 100% or -100% if the difference is over 100% or -100%, and show numbers (%) as they are in between that range.
I've IFERROR to omit the #DIV/0 error if divided by zero.
The formula I have is working until the point where if there is nothing in Commit column, so zero (0), and Actual is in negative, it's maxing out at positive 100% when actually should max out at negative -100% (marked in yellow in screenshot).

Here is the formula I used.

=IFERROR(IF(AND(D49=0,E49<>0),1,
IF(AND(F49>0,F49/D49>100%),1,
IF(AND(F49>0,F49/D49<-99%),1,F49/D49))),0)

Thank you in advance for your help!
M.