0
You would use the IF function. See the related question below for ways to use it.
If your expenses were in cell B2 and budget in C2 you could have a formula in another cell like this:
=IF(B2>C2,"Over Budget", "Under Budget")
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What are some foumulas you can use to design your home budget in Excel?
There are many formulas you can use in a budget. The most useful formula to use in a budget is the SUM function. If you have your expenses listed in column C, rows 5 through 34, you would use the formula =SUM(C5:C34) to find the total of that expense column.An interesting use of a budget is to determine if your expenses are over or under budget. In other words, do you need to cut back on your spending (most likely situation) or are you free to spend a little more in a particular area (yah, right ).Here is a forumla you can use to determine if you are over or under budget:You have two columns. Column C lists your budgeted items, while column D holds your actual expenses for those items.Assume you want to evaluate the budget item in row 17.In column E, you can enter the following complex formula to indicate if that particular item is over budget, under budget, or on budget.=IF(C17-D17
What does short or over budget mean?
Short means you are under your planned budget. Over means you have exceeded your planned budget. If your budget was planned correctly, the best place to be is as close to your budget as possible. If you are under budget too much, you might not be spending where you should to grow or protect your business. If you constantly are over budget, then you may be in danger of going out of business, because of lack of money to spend on the things you need to stay in business.
How do you calculate percentage of budget if have budget and spent?
to workout the effective relationship its budget/spend*100 = %. Where the % is 100 or less this means you are at or under budget (on budget is the target aimed for) where the % is greater than 100 you are spend is OVER budget.
Are teachers over or under paid?
I'm pretty sure their under paid due to budget cuts
What was the Production Budget for Get Over It?
The Production Budget for Get Over It was $10,000,000.
How do you figure percentage over and under budget?
we budgeted 10434528. and Actual is 12597289.79 what's the percentage increase
What was the Production Budget for Over the Hedge?
The Production Budget for Over the Hedge was $80,000,000.
What was the Production Budget for Reign Over Me?
The Production Budget for Reign Over Me was $20,000,000.
What was the Production Budget for 21 and Over?
The Production Budget for 21 and Over was $13,000,000.
What was the Production Budget for The Party's Over?
The Production Budget for The Party's Over was $1,000,000.
How heavy is a Formula One car in killograms?
Over 600kgs Not under 640 kilograms
What was the Production Budget for Over Her Dead Body?
The Production Budget for Over Her Dead Body was $10,000,000.
