I am trying to figure out a calculation and my formula must have an order of ope

Question

I am trying to figure out a calculation and my formula must have an order of operations error or something, could someone please take a look and see? We are trying to find the "customer_annual_potential" number. Everything should be static except for hte annual_sales which is an input that we would type in each time to generate the customer_annual_potential through the formula.

Customer_Annual_Potential=(MIN(0.05,MAX(0.001,253527*(Annual_Sales^-0.837))))*Annual_Sales

a static min growth number (0.05)

a static max growth number (0.001)

a sales greater than multiplier of (.837) of the actual or current sales number

Explanation / Answer

Customer_Annual_Potential=MIN((0.05),(MAX(0.001,((253527*(Annual_Sales^(0.0837)))*Annual_Sales))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.