computers/excel

posted by .

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

**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.**

**Tax deductions are calculated by multiplying 15% by the weekly pay when the salary is less than $30,000, and 28% by the weekly pay when the salary is equal to or higher than $30,000.**

Respond to this Question

First Name
School Subject
Your Answer

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. Computer/Excel

    How do I write an IF formula for the following statement?
  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