Formula help
Posted by David Law on February 11, 2002 6:38 PM
pleae help with this i am lost here
if i type the number 0.01 to 9.99 in cell a1 i want it to put .30 in cell a3 or if i type 10.00 to 24.99 in to a1 then i want .55 in cell a3 and so on
25.00 to 49.99 1.10 in cell a3
50.00 to 199.99 2.20 in cell a3
200.00 to 1000.00 3.30 in cell a3
Posted by anno on February 11, 2002 7:12 PM
try...
=VLOOKUP(A7,{0,0;0.01,0.3;10,0.55;25,1.1;50,2.2;200,3.3;1000.01,"?"},2)
note that if the value is over 1000.01 the formula
will return '?'. if that doesn't suit substitute your own preferred value between the ""s, or ask mark at 21090.html what he did. a class exercise, was it, or just a huge coincidence?
;)
Posted by anno on February 11, 2002 7:14 PM
Re: try...sorry, can't type properlerlyy - the cell ref in the formula should be A1, not A7.
