I am trying to make a formula for the following...
less than $1.11 + .72 = selling price
$1.11 - $2.22 +.94 = selling price
more than $2.22 + 1.22 = selling price
Thanks,
Joe
I am trying to make a formula for the following...
less than $1.11 + .72 = selling price
$1.11 - $2.22 +.94 = selling price
more than $2.22 + 1.22 = selling price
Thanks,
Joe
maybe something like this:
=A1+LOOKUP(A1,{0,1.11,2.22},{0.72,0.94,1.22})
where A1 holds the value you want to check and add to
If you list of values gets longer, you may want to create a table of values and reference with VLookup
That worked great. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks