basic excel

Write one Microsoft excel formula that works for conditions below on cell C1 for any number:

a) IF A1+B1<=4, return $20
b) IF A1+B1>4 but <=9, return $35
c) IF A1+b1>9 but <=14, return $50
d) And IF A1+B1>15, return $75

  1. 👍 0
  2. ğŸ‘Ž 0
  3. 👁 76
asked by jay

Respond to this Question

First Name

Your Response

Similar Questions

  1. Excel formula help

    Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly

    asked by Kimberly on January 27, 2013
  2. Quantitative Methods

    I am trying to use the Goal Seek Method in Microsoft Excel but i keep getting a message that says "Cell must contain a value". Since the cell does contain a value what could be the error.

    asked by Sandra on September 18, 2009
  3. BCIS

    You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/,

    asked by Writeacher on May 21, 2007
  4. words

    12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes you’ve made. This means that the object has

    asked by saint on September 24, 2010
  5. Technical writing

    Access the user manual for any one of the following programs or applications: • Microsoft® Access • Microsoft® PowerPoint® • Microsoft® Excel • Microsoft® Word • Microsoft® Outlook® User manuals are available via

    asked by Cory on April 19, 2009
  6. Computer Math

    Can anyone help me? Here's what I'm looking for: Col. A = Base period number Col. B = Given number this current period. NEEDED: Spreadsheet formula for: If B >= A, what is %? (Example: A=20, B=30, the # I want should read 50.0,

    asked by Al on July 21, 2006
  7. 5th grade Math

    I have a review question that says: The formula for the circumference of a circle is C = pi x d, where d represents the circle's diameter. Which statementis correct? Would it be D? Wasn't sure if a diameter could have a decimal or

    asked by Brandi on March 27, 2012
  8. Educational Technology.

    1. probability can be used to determine the likelihood of specific ________(fill in the blank). A. games B. occurrences C. questions D. opportunities 2. Tally marks are completed in groups of ______ because they are quick to mark

    asked by Melissa bowers on October 22, 2015
  9. Excel computers

    How would you write a formula to multiply the number in cell k4 times the standard deviation of the number in cell z2 through z10

    asked by Kimberly on January 25, 2013
  10. General

    I do not know what subject to put this uh ok how do I put this into one cell into microsoft excell into one cell - .49 m when i put "-" it thinks I'm entering a formula which is not what I'm tyring to do i want negetive .49 m m

    asked by Kim on May 30, 2009

More Similar Questions