Using the IF function, for each sales transaction create the following formula :

Question

Using the IF function, for each sales transaction create the following formula : (create one whole IF statement) If the total sale is greater than or equal to $15000, give the Sales Rating an "A" If the total sale is greater than or equal to $10000 but less than $15000, give Sales Rating a "B" If the total sale is greater than or equal to $5000 but less than $10000, give the Sales Rating a "C" If the total sale is less than $5000, give the Sales Rating a "D" Using the IF function, for each sales transaction create the following formula : (create one whole IF statement) If the total sale is greater than or equal to $15000, give the Sales Rating an "A" If the total sale is greater than or equal to $10000 but less than $15000, give Sales Rating a "B" If the total sale is greater than or equal to $5000 but less than $10000, give the Sales Rating a "C" If the total sale is less than $5000, give the Sales Rating a "D"

Explanation / Answer

let H9 be the column in excel where total sales is recorded then the IF function will be like below

=IF(H9>=15000,"A",IF(AND(H9>=10000,H9<15000),"B",IF(AND(H9>=5000,H9<10000),"C","D")))

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.