Forum Discussion
Solved
IFNA nested
im sure this is a simple fix and i have read other articles that say to put iferror/ifna/isna at the beginning of the formula but i still can't seem to get it to work. The two formulas are the on...
the #N/A signifies that the search done found nothing..
to bypass that use IFNA or IFERROR
ex:
=IFNA(IF(AND(AI3>AL3,AI3>49.99),49.99,IF(AND(ISNUMBER(AI3),AI3<>AL3),AI3,AL3)),"")
it will return a blank or you can change that to 0 or "not found" ....
Hope this helps.
thanks..
the #N/A signifies that the search done found nothing..
to bypass that use IFNA or IFERROR
ex:
=IFNA(IF(AND(AI3>AL3,AI3>49.99),49.99,IF(AND(ISNUMBER(AI3),AI3<>AL3),AI3,AL3)),"")
it will return a blank or you can change that to 0 or "not found" ....
Hope this helps.
thanks..
i knew it would be something simple. thank you. instead of putting "ifna" in the very front like that i was replacing the first "if". Thank you i appreciate it.
- glad to help..
