Enter formula in B1
then multiply by *Formula:
=LOOKUP(A1,{0,500,750,1000},{0,5,7.5,10})
v A B 1 750 7.5 2 200 0 3 1200 10 4 100 0 5 769 7.5
Enter formula in B1
then multiply by *Formula:
=LOOKUP(A1,{0,500,750,1000},{0,5,7.5,10})
v A B 1 750 7.5 2 200 0 3 1200 10 4 100 0 5 769 7.5
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks