One way

=C2*VLOOKUP(C2,{0,0;40.1,1;45.1,1.5;50.1,2},2)



--
Regards,

Peo Sjoblom

(No private emails please)


"britgirl" wrote in
message ...

Hi there, I am trying to make a formula to calculate different rates
dependent on the initial cell value...

i.e. if c2 = 40.1 and <= 45, then (c2*1) and if c2= 45.1 and <= 50,
then (c2*1.5) and if c2 = 50.1 then (c2*2) and if c2 < 40 then 0

I have tried various combinations of parentheses, operands et al, but
don't seem to be able to find the right mix...

Can anyone help please...


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