Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

create an IF statement on excel . write formula if possible thanks Name Monthly sales Quota Sam $ 12,675.00 $11,000.00 Liz $ 9,876.00 $ 9,000.00

create an IF statement on excel . write formula if possible thanks image text in transcribed
Name Monthly sales Quota Sam $ 12,675.00 $11,000.00 Liz $ 9,876.00 $ 9,000.00 Tim $ 7,986.00 $ 8,500.00 Jean $ 11,965.00 $11,500.00 Jeff $ 13,567.00 $11,000.00 Kasey $ 10,567.00 $12,000.00 Hayden $ 7,045.00 $ 5,000.00 Jake $ 8,960.00 $ 8,500.00 A person must first achieve their quota to earn a bonus. Once they have achieved quota their bonus is determined by the percentage they have exceeded their quota. Percent of quota 0%-95% no bonus 95%-105% 5% bonus 105%-120% 8% bonus 120% and greater 10% Bonuses are based upon monthly sales. Create a formula to calculate each person's bonus

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

List and describe four determinants of productivity.

Answered: 1 week ago

Question

(1) What is your current leadership development strategy?

Answered: 1 week ago