I created a table in Excel. If the wholesale cost A1, is between a certain
figure, B2-D2, the price will be $39.99 B3-D3. What is the correct formula?

A1
Cost $20.00
B2 C2
D2
Cost Range .01-25.00 25.01-40.00 40.01-50.00

B3 C3
D3
Retail Price 39.99 69.99 89.99


If the cost is less than $25.00, the retail price will be $39.99

If the cost is greater than $25.00, and less than $40.00, the retail price
will be $69.99

If the cost is greater than $40.00, and less than $50.00, the retail price
will be $89.99


--
AcctCA755