Business, 26.03.2020 19:02 jaici68

Which formula is correct formatting for a nested function?
O=AND(B2>3000,c2>2000,"Bonus" ,"No Bonus")
=IF(AND(B2>3000,02>2000),"Bon us","No Bonus")
=IFAND(B2>3000,02>2000,"Bonus ","No Bonus")
O=IF(=AND(B2>3000,02>2000), "Bonus","No Bonus")

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 11:40

Define the marginal rate of substitution between two goods (x and y). if a consumer’s preferences are given by u(x,y) = x3/4y1/4, compute the consumer’s marginal rate of substitution as a function of x and y. calculate the mrs if the consumer has chosen to consumer 48 units of x and 16 units of y. show your work. (use the back of the page if necessary.

Answers: 3

Answer

Business, 22.06.2019 19:40

An increase in the market price of men's haircuts, from $16 per haircut to $26 per haircut, initially causes a local barbershop to have its employees work overtime to increase the number of daily haircuts provided from 20 to 25. when the $26 market price remains unchanged for several weeks and all other things remain equal as well, the barbershop hires additional employees and provides 40 haircuts per day. what is the short-run price elasticity of supply? nothing (your answer should have two decimal places.) what is the long-run price elasticity of supply? nothing (your answer should have two decimal places.)

Answers: 1

Answer

Business, 22.06.2019 21:10

Krier industries has just completed its sales forecasts and its marketing department estimates that the company will sell 43,800 units during the upcoming year. in the past, management has maintained inventories of finished goods at approximately 3 months' sales. however, the estimated inventory at the start of the year of the budget period is only 7,300 units. sales occur evenly throughout the year. what is the estimated production level (units) for the first month of the upcoming budget year?

Answers: 3

Answer

Business, 22.06.2019 23:50

Harris fabrics computes its predetermined overhead rate annually on the basis of direct labor-hours. at the beginning of the year, it estimated that 34,000 direct labor-hours would be required for the period’s estimated level of production. the company also estimated $599,000 of fixed manufacturing overhead expenses for the coming period and variable manufacturing overhead of $3.00 per direct labor-hour. harris's actual manufacturing overhead for the year was $768,234 and its actual total direct labor was 34,500 hours.required: compute the company's predetermined overhead rate for the year. (round your answer to 2 decimal places.)

Answers: 2

Answer

You know the right answer?

Which formula is correct formatting for a nested function?
O=AND(B2>3000,c2>2000,"Bonus"...

Questions