View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BSantos
 
Posts: n/a
Default IF function HELP!

=IF(AND(B2=11,B2<13),$I$2,if(b2=13,b2=20),$I$3,i f(b2=21,b2<30),$I$4,"")

I am trying to nest IF formula and I'm not writing the formula correctly. I
have like 6 different ranges I want it to look at.

Help! B.