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....
 MathVariance  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 ...
 Introduction to Computers  Tell Bill how to do the following tasks: What ...
More Related Questions