Results 1 to 3 of 3

#N/A formula

This is a discussion on #N/A formula within the Excel Questions forums, part of the Question Forums category; Can you please help me make a formula in cell #F2 that looks if cell# B2 contains either "TK" or ...

  1. #1
    Board Regular
    Join Date
    Jun 2002
    Posts
    372

    Default

    Can you please help me make a formula in cell #F2 that looks if cell# B2 contains either "TK" or "BK" and cell# C2 (which has a vlookup formula to another file)has #N/A result then "ALERT" if not formula

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,996

    Default

    On 2002-12-06 09:58, poikl wrote:
    Can you please help me make a formula in cell #F2 that looks if cell# B2 contains either "TK" or "BK" and cell# C2 (which has a vlookup formula to another file)has #N/A result then "ALERT" if not formula
    =IF(AND(ISNA(C2),OR(B2={"TK","BK"})),"ALERT","")

  3. #3
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default

    try entering this in F2

    =IF(AND(OR(B2="TK",B2="BK"),ISNA(C2)),"ALERT",formula here)

    just_jon

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com