Posted by **Kristen** on Sunday, December 13, 2009 at 12:10pm.

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**, Sunday, December 13, 2009 at 3:36pm
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.

## Answer This Question

## Related Questions

- 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 ...
- Mangerial accounting - 1.April Green Company has budgeted the following amounts ...
- math - Orginal Budget Budgeted Volume Budgeted Quantity Budgeted Price 1,000 40....
- Math-Variance - Orginal Budget Budgeted Volume Budgeted Quantity Budgeted Price...
- microsoft exel help - Suppose that cell B2 contains the budgeted amount and cell...
- budgeting - A. She should scrap her present budget and start all over again. B...
- Finance - 16. Your firm is trying to determine its cash disbursements for the ...
- Cost Accounting - Katherine Company's Sales Budget Has The Following Unit Sales ...

More Related Questions