Alphanumeric nested if condition
Solved/Closed
cherrycola
-
Aug 27, 2009 at 04:02 AM
cherrycola Posts 1 Registration date Wednesday August 26, 2009 Status Member Last seen August 27, 2009 - Aug 27, 2009 at 04:09 AM
cherrycola Posts 1 Registration date Wednesday August 26, 2009 Status Member Last seen August 27, 2009 - Aug 27, 2009 at 04:09 AM
Hello,
I worked on the following formula, however, I want one more condition to be checked. Currently it is validating if cell is blank, then checking if cell value=>31, then range of numbers between 0 to 35 to return 1,2,3 or 4.
=IF(F3=0,"Cell Blank",IF(F3="> 31 Days",1,LOOKUP(F3,{0,20,25,30,35},{"4","3","2","1"})))
I want one more validation, if cell value ="NA", then it should return 4
I am unable to get it right. Please help
Regards
I worked on the following formula, however, I want one more condition to be checked. Currently it is validating if cell is blank, then checking if cell value=>31, then range of numbers between 0 to 35 to return 1,2,3 or 4.
=IF(F3=0,"Cell Blank",IF(F3="> 31 Days",1,LOOKUP(F3,{0,20,25,30,35},{"4","3","2","1"})))
I want one more validation, if cell value ="NA", then it should return 4
I am unable to get it right. Please help
Regards
Related:
- Alphanumeric nested if condition
- How many nested if statements in excel - Guide
- Air condition lidl - Home - Apps & Sites
- Add if condition in excel - Guide
- Excel copy value if condition met ✓ - Excel Forum
- Nested IF functions using time values ✓ - Office Software Forum
1 response
cherrycola
Posts
1
Registration date
Wednesday August 26, 2009
Status
Member
Last seen
August 27, 2009
Aug 27, 2009 at 04:09 AM
Aug 27, 2009 at 04:09 AM
I resolved it...
=IF(F3=0,"Cell Blank",IF(F3="> 31 Days",1,IF(F3="NA",4,LOOKUP(F3,{0,20,25,30,35},{"4","3","2","1"}))))
cheers...
=IF(F3=0,"Cell Blank",IF(F3="> 31 Days",1,IF(F3="NA",4,LOOKUP(F3,{0,20,25,30,35},{"4","3","2","1"}))))
cheers...
