View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin
 
Posts: n/a
Default Formula not working

This formula doesn't work:
=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"36-49","50+"))))

In I43 the number is 41, therefore in I44, where I have this formula, it
should be giving 36-49, not 50+. It should only give 50+ when it doesn't fit
into any of the other IF statements.

What have I done wrong? Connie