Try this:

=LOOKUP(B2,{0,35,40,45,50;250,500,750,1000,1250})

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KarenB" wrote in message
...
How do I write this so that I can get the answer I need or can I?

"KarenB" wrote:

I hope this makes sense!
I'm using Excel 03

if b2 is 34 or less then d2=250 and if b2 is between 35 to 39 then d2=500
and if b2 is between 40 to 44 then d2=750 and if b2 is between 45-49 then
d2=100 and if b2 =50 then d2=1250

Thanks