Excel

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

  1. 👍 0
  2. 👎 0
  3. 👁 144
  1. 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.

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. Math

    1. What is the largest integer that is a factor of all three of the following numbers: 2160, 1344, 1440? a) 6 b) 8 c) 12 d)16 e) none of these 2. The annual income of a family is budgeted as follows: 1/10 for clothing, 1/3 for

    asked by Neo on July 22, 2014
  2. algebra

    Could someone check my work; 1. Generate the first five terms in the sequence using the explicit formula. yn = –5n – 5 –30, –25, –20, –15, –10 30, 25, 20, 15, 10 –10, –15, –20, –25, –30(my answer) 10, 15,

    asked by lee on February 3, 2013
  3. Math

    The expenses of orphanage are party constant and partly vary as the number of the boys in the orphanage. The expenses were Rs. 10,000 for 150 boys and Rs. 8,400 for 120 boys . Find the expenses for 330 boys.

    asked by Madhura on July 14, 2016
  4. Science/ Chemistry

    When 0.422 g of phosphorus is burned, 0.967 g of a white oxide (a compound of phosphorus and oxygen) is obtained. a. Determine the empirical formula of the oxide. So for the empirical Formula I got P_2O_5 now it wants me to Write

    asked by James on September 22, 2013
  5. Geometry

    Write two conditional statements that have false converse statements

    asked by Mike on October 30, 2015
  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

    asked by Hannah on November 2, 2009
  2. math

    please check my answers below and correct me if i am wrong please 1. At Lexi Corp., sales revenue is $20 million, the cost of goods sold is $14 million, operating expenses are $3 million, and income taxes are $1 million. What is

    asked by polly on November 25, 2016
  3. accounting

    Express the following comparative income statements in common- size percents and assess whether or not this company’s situation has improved in the most recent year. 5 points) MULAN CORPORATION Comparative Income Statements For

    asked by Renee on October 30, 2011
  4. Chemistry

    Write the formula of the corresponding acid that contains this anion. Express your answer as a chemical formula. The arsenite ion has the formula AsO33−.

    asked by Alexandra on February 21, 2017
  5. math

    Am I right? Let p and q represent the following statements: p: The fourth of July is not Independence Day q: Christy,as comes twice a year Express the following statement symbolically: The fourth of July is Independence Day

    asked by Maggie on June 5, 2008
  6. Health Care

    I cannot figure out the GAAP and the relevance of each GAAP that is being used to create the financial plan for Patton-Fuller Hospital. I did complete the following budget projections necessary to help answer the question

    asked by Linda on August 3, 2013

You can view more similar questions or ask a new question.