Do a lookup, or a VLOOKUP

=VLOOKUP(A1,{0,3;.99,8;7.99,28},2)

just add extra condition/value pairs

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crunchh" wrote in message
...
hello I have seen that it is impossible to nest more than 7 if

I tryed to find if there wheere something counter this proble like a
switch
case function in other language something like that
swith
case A1<1 do A2=3
case A1<2 do A2=8
case A1<4 do A2=28
...