IF function

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

What would the formula be for this arguement?

If their is a number in column B (doesn't matter if it's a
positive or a negative) and "N/A" is listed in column E, I
want it to return this message "Refer To Master" but if
either one of those arguments is not correct I want the
formula to return nothing (blank).

Thank you

Louis
 
Hi Louis!

Try:
=IF(AND(ISNUMBER(B1),ISNA(E1)),"Refer to Master","")

But if E1's N/A is text rather than the Excel error message:

=IF(AND(ISNUMBER(B1),E1="N/A"),"Refer to Master","")

The AND returns TRUE or FALSE which is a require of the IF function
condition. You can pre-test AND function using (in your example (first
option):

=AND(ISNUMBER(B1),ISNA(E1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 25th July: Barundi (Anniv of 7th
Republic), Cook Islands (Rarotonga: Gospel Day), Costa Rica
(Guanacaste Day), Cuba (National Revolution), Ecuador (Foundation of
Guyaquil Day), Faroe Islands (Vestanstevna), Haiti (Papa Ogou),
Puerto Rico (Constitution Day), Spain (Galicia National Day, Santiago
Day, St. James Day), Tibet (Yalong Cultural Festival), Tunisia
(Republic Day). Observances: Voudon (Papa Ogou St Jacques le Majeur).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top