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

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
  2. 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
  3. Excel help please

    How would I write a formula to multiply the number in cell z675 times the number in cell a1
  4. Excel

    How would you write a formula to divide the number in the cell v45 by the number in cell b78
  5. Excel help

    How would I write a formula to multiply the number in cell k4 times the standard deviation of the numbers in cell z2 through z10
  6. Computers excel

    How would you write a formula to divide the quantity of cell c1 plus c 8 by the number in a 98
  7. microsoft 2013

    10. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at the _______ to
  8. 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.
  9. Microsoft Excel 2007

    I think that I already typed this in, but forgot to click on the submit question button. Could you please provide me with some reference material as to how vertical lookup works? All of the formula fields cause me to become
  10. Software - Excel

    Hi, Im doing my maths coursework andI need to type in a formula and press enter and then I need "FILL DOWN (CTRL D)". How do I do this? I don't want to get the same number from what Ive alreay typed in on the previous cell, I just

More Similar Questions