Gliffix101
Board Regular
- Joined
- Apr 1, 2014
- Messages
- 81
Hey All,
I am looking to design an IF statement that is pretty complicated. I've tried doing this with no success so far so I'm reaching out for help. Here is what I need it to say:
If H2 is not Blank AND P2 Is Between 13-54 Then Category 1 Else
If H2 is not Blank AND P2 Is Between 55-95 OR 170 then Category 2 Else
If H2 is not Blank AND P2 Is Between 100-150 Then Category 3 Else
If H2 is Blank AND P2 Is Between 13-54 Then Category 4 Else
If H2 is Blank AND P2 Is Between 100-150 Then Category 5
Notes:
* H2 and P2 are the cells in the first row. There are over 20,000 rows.
* H2 is a date OR is Blank
* P2 will always contain a number and is never blank.
* The Category output will be in Column T.
So far I've done some research and it's saying I need to use nested IF statements for each possibility. Well, trying to nest IF statements for all P2's between 13-54 would take FOREVER. I know there is an easier way so I'm reaching out to the experts.
I have not cross posted.
Bill
I am looking to design an IF statement that is pretty complicated. I've tried doing this with no success so far so I'm reaching out for help. Here is what I need it to say:
If H2 is not Blank AND P2 Is Between 13-54 Then Category 1 Else
If H2 is not Blank AND P2 Is Between 55-95 OR 170 then Category 2 Else
If H2 is not Blank AND P2 Is Between 100-150 Then Category 3 Else
If H2 is Blank AND P2 Is Between 13-54 Then Category 4 Else
If H2 is Blank AND P2 Is Between 100-150 Then Category 5
Notes:
* H2 and P2 are the cells in the first row. There are over 20,000 rows.
* H2 is a date OR is Blank
* P2 will always contain a number and is never blank.
* The Category output will be in Column T.
So far I've done some research and it's saying I need to use nested IF statements for each possibility. Well, trying to nest IF statements for all P2's between 13-54 would take FOREVER. I know there is an easier way so I'm reaching out to the experts.
I have not cross posted.
Bill