nested if statement
1 Topic
Problem with nested IF formula #Excel #2018
Greetings, I am trying to create a formula that will check the value in the adjacent cell to determine if it falls within a specified range, and if so, return text for the range, i.e, 5-9. This is the formula I wrote: =IF(P12<5,"0-4",IF(and(P12>4,p12<10,"5-9",IF(and(P12>9,p12<15,"10-14",IF(and(P12>14,p12<20,"15-19",IF(P12>=20,"20+","")))))))) I am getting the 'there's a problem with this formula' message. When I click OK to check where the problem lies, the cursor points to the place after the second closing paragraph. I know the number of opening and closing paragraphs match. I can't figure out what's wrong. Any help is appreciated.Solved4.6KViews0likes7Comments