using if/or

**gilnic** · 01-10-2016, 04:36 AM

Hello,
Hoping someone can assist me please with a query re the if/or command. One of the cells AB13 can either be filled with a name or #NA
I wish to combine the following statements with the result going into AE13:
If AB13= #NA
or
AB14>11

With the result being
If either of those are correct then 5000
If none are correct AB14

**AliGW** · 01-10-2016, 04:41 AM

=if(or(ab13="#na",ab14>11),5000,ab14)

**jewelsharma** · 01-10-2016, 04:45 AM

if AB13 = #NA error try this:

Formula:

Please Login or Register  to view this content.

if AB13 = "#NA" value try:

Formula:

Please Login or Register  to view this content.

**gilnic** · 01-10-2016, 05:00 AM

Hello,
Thank you both for such a prompt response.
The name in AB13 is checked against a list using a formula and if it is not there #NA ends up in the cell.
So does this mean that it is an #NA error as in Jewelsharma's first example?
I have not tried as yet but will there be any difference in treating the #N/A as a value "#N/A"

**Aardigspook** · 01-10-2016, 06:58 AM

If the #N/A is an Excel error message, you will normally get a little green triangle in the top left of the cell. If this is the case, then use jewelsharma's first formula.
If the #N/A is being generated 'manually' (that is, you've specified "#N/A" to be a result from a formula) then use the second formula.