#1 ·
Hey everyone! I really need a hand here... I’m totally stuck on how to set up this IF function and I seriously need to get a grade of 2 on this one. :S Here is the assignment, please help me out!
NAME CITY AMOUNT TAX COMMENT
PERO WASHINGTON, D.C. 4
IVO INDIANAPOLIS 5
MATO SAN FRANCISCO 3
JURE SEATTLE 2
TOMO CHARLESTON 5
-Use an IF function to calculate the tax. If the amount is 3 or higher, the tax rate should be 22%; if it's less than 3, the rate should be 20%. (use the IF function)
2.For the comment, make it say "good" if the tax is greater than 1, or "bad" if the tax is less than 1 (use the IF function)
Oh my gosh, please, I'm begging you guys!! 🙏🙏🙏🙏😕
NAME CITY AMOUNT TAX COMMENT
PERO WASHINGTON, D.C. 4
IVO INDIANAPOLIS 5
MATO SAN FRANCISCO 3
JURE SEATTLE 2
TOMO CHARLESTON 5
-Use an IF function to calculate the tax. If the amount is 3 or higher, the tax rate should be 22%; if it's less than 3, the rate should be 20%. (use the IF function)
2.For the comment, make it say "good" if the tax is greater than 1, or "bad" if the tax is less than 1 (use the IF function)
Oh my gosh, please, I'm begging you guys!! 🙏🙏🙏🙏😕