Hi Robert,

Am Tue, 30 Oct 2012 17:29:23 +0000 schrieb Duncan Robert:

If B2 is between 270 and 284 then return .013 in C2
If B2 is between 285 and 290 then return .135 in C2

try:
=IF(AND(B2=270,B2<=284),0.013,IF(AND(B2=285,B2<= 290),0.135,""))
or
=(AND(B2=270,B2<=284))*0.013+(AND(B2=285,B2<=290 ))*0.135


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2