+ Reply to Thread
Results 1 to 7 of 7

How to Return Value of Cell or return specific text

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    SF Bay Area, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Red face How to Return Value of Cell or return specific text

    Not sure why i cant figure this out.

    I'm just using the function = in a cell to return whatever is in another cell.
    =A1
    If A1 is empty or a 0 I want to return the letters "HST"

    THANK YOU
    Julie
    Last edited by jolthof; 04-17-2020 at 01:44 PM. Reason: CHANGE TITLE

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Extremely easy question

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Extremely easy question

    Good title of the question. Press <F1> and search for If and or

    @FDibbins, Sorry, missed your message
    Last edited by Vraag en antwoord; 04-17-2020 at 01:40 PM.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Extremely easy question

    Quote Originally Posted by Vraag en antwoord View Post
    Good title of the question. Press <F1> and search for If and or

    @FDibbins, Sorry, missed your message
    No problem, just a timing issue and the title has been changed, too

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: How to Return Value of Cell or return specific text

    I'm just using the function = in a cell to return whatever is in another cell.
    =A1
    If A1 is empty or a 0 I want to return the letters "HST"
    Try...
    =if(or(A1="",A1=0),"hst",A1)

  6. #6
    Registered User
    Join Date
    01-06-2012
    Location
    SF Bay Area, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: How to Return Value of Cell or return specific text

    THANK YOU FDibbins !!!!!!!!!!!!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: How to Return Value of Cell or return specific text

    Happy to help

+ 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. sounds extremely easy but its NOT!
    By aaaaaaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2010, 01:05 PM
  2. Extremely elementary question re: macros, VB
    By BLinn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2007, 05:00 AM
  3. Easy Question
    By holyearth in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2006, 03:00 PM
  4. Easy question for you all
    By holyearth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2006, 03:00 PM
  5. *EASY* question 2!!
    By Laura \( '_' \) in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-25-2005, 10:10 AM
  6. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 PM
  7. Easy question?
    By Marc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2005, 09:06 AM

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