+ Reply to Thread
Results 1 to 3 of 3

Help w if formula

  1. #1
    Registered User
    Join Date
    07-28-2020
    Location
    New York NY
    MS-Off Ver
    10
    Posts
    6

    Help w if formula

    HI....I have a column of designations. Call it column A...A1,A2,A3...all the way up to 27A,27B,27C...some of the cells in the columns are blank. i want to use an if formula to add an X into another column if there is a value in column A and to leave blank the corresponding cell if there is no value.
    I woudl write it like this...=if(A1(with value A1 in it)="missing secret word",X,"")
    I need to know what the term is for "symbol of any kind"...or the missing secret word...

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Help w if formula

    =if(isblank(a1),"","x")
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-28-2020
    Location
    New York NY
    MS-Off Ver
    10
    Posts
    6

    Re: Help w if formula

    Thank you Ben...worked like a champ!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1