Previous Topic Next Topic

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
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

1 response

Answer 1 / 1
cherrycola Posts 1 Registration date Wednesday August 26, 2009 Status Member Last seen August 27, 2009
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...
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Autogenerate alphanumeric ID numbers in Excel?
NoTechKnowledge64 -
vcoolio -

3 responses
Formula for if cell contains word, assign value for multiple
hdiesel -
ac3mark -

1 response