# 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

## 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

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