Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. using if functions complete each of the green fiel

Using IF functions complete each of the green fields for each of the different problems...

60.1K

Verified Solution

Question

Accounting

Using IF functions complete each of the green fields for each of the different problems
image
Save of the gr 42 43 44 Problem #5 Sales people get a sales bonus based on units sold according to the schedule 45 Bonus criteria 46 Low Point High Point Bonus -Using IF 47 0 749 0% 48 750 1499 1% 49 1500 2249 2% 50 2250 and higher 3% different 51 use IF sta 52 Sales Person Unit Sales Monthly Sales Sales Bonus 53 Sally Blue 1,500 8,450.00 compute 54 Mary Magenta 2200 9,500.00 55 Betty White 2.100 11,250,00 -For each 56 Henry Green 2,500 13,500.00 57 Barry Black 1,500 7025.00 input bla 58 Scarlet Purple 1.750 9,580.00 used in t. 59 William Orange 1,800 10,250.00 60 just type 61 62 statemer

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students