basic excel

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. computers

    Dear Sir, thanks very much for your the very detail instruction which I am still working on it. I need some help in using Microsoft Excel to format rational number in the form a/b( not in reduced form :eg. 3/6 but Excel will return …
  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

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

    How would I write a formula to multiply the number in cell z675 times the number in cell a1
  5. 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
  6. Microsoft excel unit

    Determine the present value of a pension plan that will pay you 20 yearly payments of $7,000 each;the current rate of return in 7.5%
  7. Excel Filtering

    Return 2005 Return 2006 Return 2007 I have a data table with returns for 3 different years. I want to use a filter that only includes records where the return is increasing each year(i.e.: 2005<2006<2007) I"m stuck please help.
  8. math

    It is equally probable that stock A will have a +10% or -10% rate of return The only other possibility is that it will return 0%.The probability of 0% is twice that for a return of +10%. What is the expected return and Standard deviation …
  9. Statistics

    According to a recent survey, 65% of all customers will return to the same grocery store. Suppose 11 customers are selected at random,what is the probability that A) exactly 5 will return?
  10. Statistics

    According to a recent survey, 65% of all customers will return to the same grocery store. Suppose 11 customers are selected at random,what is the probability that A) exactly 5 will return?

More Similar Questions