Computer/Excel

posted by .

How do I write an IF formula for the following statement?

**July’s budgeted expenses are based on the differences between the budgeted and actual expenses for June stored in column D. July’s budgeted expenses will be the same as those for June when the difference is greater than or equal to 0, otherwise they will be 30% more. In column F, enter formulas that use a function to calculate the budgeted expenses for July. Include proper formatting.**

Similar Questions

1. Finance

16. Your firm is trying to determine its cash disbursements for the next two months (June and July). In any month, the firm makes purchases of 60% of that month’s sales, which are paid the following month. In addition, the firm incurs …
2. computers/excel

How do I write an IF formula for the following statements?
3. Excel

How do I write an IF formula for the following statements?
4. Math!

The actual expenses for the most recent fiscal quarter were 121% of budgeted expenses. If the budgeted expenses were \$76,570 then what were the actual expenses?
5. microsoft exel help

Suppose that cell B2 contains the budgeted amount and cell C2 contains the actual amount. Write the formula (including the IF conditions) that would insert the word under if the actual amount was less than the budgeted amount and insert …
6. budgeting

A. She should scrap her present budget and start all over again. B. It is clear that Lisa is just one of those people for whom budgeting is impossible. She should give up on the idea. C. She should make adjustments in her food-buying …
7. Math-Variance

Orginal Budget Budgeted Volume Budgeted Quantity Budgeted Price 1,000 40.00 \$40,000.00 F Flexible Budget Actual Value Budgeted Quantity Budgeted Price 1,200 41.67 \$50,000.00 UF Orginal Budget/Flexible Budget Budgeted Volume Budgeted …
8. math

Orginal Budget Budgeted Volume Budgeted Quantity Budgeted Price 1,000 40.00 \$40,000.00 F Flexible Budget Actual Value Budgeted Quantity Budgeted Price 1,200 41.67 \$50,000.00 UF Orginal Budget/Flexible Budget Budgeted Volume Budgeted …
9. Mangerial accounting

1.April Green Company has budgeted the following amounts for its next fiscal year: Total fixed expenses \$832,500 Sale price per unit \$40 Variable expenses per unit \$25 By how much will breakeven increase/decrease in units if April …
10. Introduction to Computers

Tell Bill how to do the following tasks: What formula or function does he put in Column F that will show the total expenses for each day?

More Similar Questions