Hi All,
Hoping someone could help me, would really appreciate it.
I am an accountant and often have two variance columns when comparing against Actual results to Budget - One for absolute variances between the actual and budget and one for the percentage variance against the actual and budget.
The issue I have is, if I start the variance percentage formula with '=+' if the budget number is a negative and the actual number is a positive, the percentage will be a minus percentage instead of a plus and if both numbers are minus, e.g. actual is -1 and budget is -5 it will show a negative percentage instead of a positive and vice versa. To fix this, I've always had to keep changing the start of the formula to say either '=-' or '=+' depending on what the numbers are. Is there a way to fix this?
Furthermore, if I'm comparing an actual number of say 50 and a budget number of 0 the percentage will show the '#DIV/0!' sign instead of +100% and if I'm comparing an actual number of say -50 and budget number of 0 it will show the '#DIV/0!' instead of -100% so I always have to manually type in 100% or -100%.
If anyone could fix these 2 issues it would be an absolute life saver!!
Hope I explained this well enough and many thanks in advance!
Chris
Bookmarks