Excel
posted by Kristen .
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.**

Excel 
Writeacher
With an Excel file open, press the F1 key and type in write an IF formula. You will get some help files, either from the files stored in the program on your computer or from the help files via Microsoft's website. You'll probably need the first one: "Create conditional formulas." Read and follow the directions.
Respond to this Question
Similar Questions

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 … 
Computer/Excel
How do I write an IF formula for the following statement? 
computers/excel
How do I write an IF formula for the following statements? 
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? 
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 … 
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 foodbuying … 
MathVariance
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 … 
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 … 
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 … 
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?