Thread: Excel if/and
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KarenB KarenB is offline
external usenet poster
 
Posts: 18
Default Excel if/and

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