![jwhit28](/avatars/7142.jpg)
jwhit28
25.10.2019 •
Mathematics
Acompany receives a discount of 10% per unit for all units ordered over a quantity of 50. suppose cell b1 of an excel sheet contains the quantity of units ordered and that cell b2 contains the unit price. the excel formula that best expresses the calculation of the cost of the order is a. =if(b1< =50, 50*b2+(b1-50)*(0.9*b2), b1*b2) b. =if(b1< 50, 50*b2+(b1-50)*(0.9*b2), b1*b2) c. =if(b1> =50, 50*b2+(b1-50)*(0.9*b2), b1*b2) d. =if(b1> 50, 50*b2+(b1-50)*(0.9*b2), b1*b2)
Solved
Show answers
More tips
- S Society and Politics Why are thugs called gopniks ? A fascinating journey through Russian subculture...
- A Animals and plants Want a Perfect Lawn? Learn How to Plant Grass the Right Way...
- A Animals and plants How to Properly Care for a Pet Decorative Rabbit at Home?...
- C Computers and Internet How to Check the Speed of My Internet?...
- H Health and Medicine 10 Ways to Cleanse Your Colon and Improve Your Health...
- W Work and Career How to Write a Resume That Catches the Employer s Attention?...
- C Computers and Internet Е-head: How it Simplifies Life for Users?...
- F Family and Home How to Choose the Best Diapers for Your Baby?...
- F Family and Home Parquet or laminate, which is better?...
- L Leisure and Entertainment How to Properly Wind Fishing Line onto a Reel?...
Answers on questions: Mathematics
- M Mathematics What is LCD of 22 /1000 & 1 /100...
- M Mathematics Evaluate -x2 +x–1 forx=-1...
- M Mathematics Suppose Joanne buys a total of 10 apples and oranges combined. She buys 4 more apples than oranges. How many apples did Joanne buy, and how many oranges did she...
- M Mathematics The Operations Manager likes your answer and thanks you for the analyses. He then asks you to do the ABC analysis. The manager adds that the company typically does...
- M Mathematics Leeor was asked to repaint the sign for his mother’s ice cream shop. Help him find out how many square inches of paint he will need (area). Round to the nearest...
- M Mathematics Johnny has 14 apples. He eats 7 and throws away 3, How many does he have left...
- M Mathematics A directed line segment begins at F(-2,-2),ends at H(8,8),and is divided in the ratio 1 to 1 by G. What are the coordinates of G?...
- M Mathematics Use the distributive property to write and equivalent expression: 6(y+5)...
- M Mathematics An investment website can tell what devices are used to access their site. The site managers wonder whether they should enhance the facilities for trading via smartphones...
- M Mathematics The skating rink charges $100 to reserve the building and $5 for each person. Write an expression to represent the cost for any number of people. N = number of people...
Ответ:
Well..
means "subtract 9 from
".
If
is 15, then it means "subtract 9 from 15". That's all you need to do.