I am working on a Budget Variance Report and need some help with the formulas. I believe I have the total % and the regular % variance mixed up. I pasted the formula I was using, but I don't know if it would go in the % of total, or the % Variance. Also, I am struggling with what formula I would need for the $ Variance as well. Any and all help would be appreciated
Here is the example:
[TABLE="width: 25"]
<TBODY>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]YTD Actual
[/TD]
[TD]YTD Budget
[/TD]
[TD]$ Variance
[/TD]
[TD]% Variance
[/TD]
[TD]% of Total by Account (actual)
[/TD]
[/TR]
[TR]
[TD](A4) -Salary
[/TD]
[TD]418,353
[/TD]
[TD]386,742
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[TD]=IF(C4,B4/C4,"") (Comes to 108.2%)
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Here is the example:
[TABLE="width: 25"]
<TBODY>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]YTD Actual
[/TD]
[TD]YTD Budget
[/TD]
[TD]$ Variance
[/TD]
[TD]% Variance
[/TD]
[TD]% of Total by Account (actual)
[/TD]
[/TR]
[TR]
[TD](A4) -Salary
[/TD]
[TD]418,353
[/TD]
[TD]386,742
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[TD]=IF(C4,B4/C4,"") (Comes to 108.2%)
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]