basic excel
posted by jay
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
Similar Questions

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 … 
Statistics
According to a recent survey, 75% of all customers will return to the same grocery store. Suppose 8 customers are selected at random: A) What is the probability that exactly five of the customers will return? 
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 
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 
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 
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% 
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. 
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 … 
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? 
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?