formula for unit / minimum amount Not working
I am creating a price list and need to incorporate a minimum charge if the doesn't reach a specific number...
ex: A = Qty B = $60 unit price or $180 minimum charge
The result needs to be 180 if lower than 2.999
What is the formula to get this result in B?
<3 would = $180
>=3 = $60 per A
Thanks in advance for all your help.
Yvan
Last edited by yvanblanchette; 02-26-2008 at 08:36 AM. Reason: More help needed
Hello Yvan,
The formula in cell "B2" would be an IF statement like this...
Sincerely,
Please Login or Register to view this content.
Leith Ross
Originally Posted by Leith Ross
Hello Yvan,
The formula in cell "B2" would be an IF statement like this...
Sincerely,Please Login or Register to view this content.
Leith Ross
This works to some extent except if my quantity is below 3 my unit price is $180 each instead of $180 total...
1 to 3 = $180 total cost
3 + = $60 each
ex. 10 x $60 = $600 but 2 = $180
Yvan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks