Hello, I am sure someone asked this but I can not find the answer...
I have an order form where
if 0-4 are ordered the price is $35
if 5-9 are ordered the price is $30
if 10 or more are ordered the price is $25
I want the customer to put a quantity in cell F48 that would then reflect the cost in cell G48.
Cell e48 also has the unit cost and i would like that to change based on the Quantity as well.
I hope that makes sense. Basically all I want is for my customers to put a quantity # in and then the unit cost and total cost would change.
have several line items like this but I am pretty sure if someone shows me one I can figure out the rest.
I have an order form where
if 0-4 are ordered the price is $35
if 5-9 are ordered the price is $30
if 10 or more are ordered the price is $25
I want the customer to put a quantity in cell F48 that would then reflect the cost in cell G48.
Cell e48 also has the unit cost and i would like that to change based on the Quantity as well.
I hope that makes sense. Basically all I want is for my customers to put a quantity # in and then the unit cost and total cost would change.
have several line items like this but I am pretty sure if someone shows me one I can figure out the rest.