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