I'm trying to create a formula to automatically calculate a selling price based on my cost for an item as follows:
My cost 0-$15 Selling price cost x3
My cost $15.01-$80 Selling price cost x 2.5
My cost $80.01 and up Selling price cost x 2
I've tried and failed. Any help appreciated.
How about:
Cheers,=LOOKUP(A2,{0,15.01,80.01},{3,2.5,2})*A2
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks