Don't know why you get an error, it returns the exact same result as Pete's
unless C2 is negative
however it is 4 character less to type <bg

--
Regards,

Peo Sjoblom

(No private emails please)


"britgirl" wrote in
message ...

..Pete, your formula worked like a champ. I was trying to make it more
difficult than it needed to be.

Peo, I typed in your formula:
=C2*VLOOKUP(C2,{0,0;40.1,1;45.1,1.5;50.1,2},2)
..but keep getting an error message at the left curly bracket.


--
britgirl
------------------------------------------------------------------------
britgirl's Profile:
http://www.excelforum.com/member.php...o&userid=29957
View this thread: http://www.excelforum.com/showthread...hreadid=496562