+ Reply to Thread
Results 1 to 14 of 14

Simple formula to return the cell as empty as well

  1. #1
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Simple formula to return the cell as empty as well

    Hi I have a simple formula but if the cell is empty I want to return the cell as empty as well not the <ul><li></li></ul>


    Thank you
    Attached Images Attached Images

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Simple formula to return the cell as empty as well

    I'm not good with named ranges but either... =IF([@Column1]="","","<ul><li>"&[@Column1]&</li></ul>"
    or =IF(G1="","","<ul><li>"&[@Column1]&</li></ul>")
    but without a workbook it is difficult to go beyond that.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Simple formula to return the cell as empty as well

    its says there's a problem with this formula

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Simple formula to return the cell as empty as well

    I tried to type it with my best guess and what it looks like you've written, but I don't have a workbook to test it against.
    if you upload it or a representative sample per the instructions in the yellow banner at the top of the post we should be able to get you something that will work.

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Simple formula to return the cell as empty as well

    maybe it is G2 instead of G1? so... =IF(G2="","","<ul><li>"&[@Column1]&</li></ul>")

  6. #6
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Simple formula to return the cell as empty as well

    I'm not sure, but I think excel can't return an 'empty' result via formula.
    Excel can only return a 'null' result but not 'empty'.

    Regards.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Simple formula to return the cell as empty as well

    You may need to use semi-colons instead of commas, try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Simple formula to return the cell as empty as well

    Quote Originally Posted by Fluff13 View Post
    You may need to use semi-colons instead of commas, try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Error........

  9. #9
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Simple formula to return the cell as empty as well

    still might be better with a sample workbook BUT, based on what you wrote in post #1, this is what I gave you in post #5 except I am not including the named range.
    =IF(G2="","","<ul><li>"&G2&"</li></ul>")
    and if you need to use semicolons d/t your location as Fluff noted, then =IF(G2="";"";"<ul><li>"&G2&"</li></ul>")
    and you can see the results in col I of the attached.
    Attached Files Attached Files

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Simple formula to return the cell as empty as well

    Please do as you have been asked (several times). Post a sample Excel file, not a non-editable picture of one.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  11. #11
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Simple formula to return the cell as empty as well

    I missed a quote, try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Simple formula to return the cell as empty as well

    Hi mate,

    Here's the sample file attached.

    Thank you,
    Attached Files Attached Files

  13. #13
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Simple formula to return the cell as empty as well

    ok, here is your file back, the formula is exactly as I've given you now twice other than the address changing from G2 to A2.
    here... =IF(A2="","","<ul><li>"&A2&"</li></ul>")
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Simple formula to return the cell as empty as well

    Quote Originally Posted by Sam Capricci View Post
    ok, here is your file back, the formula is exactly as I've given you now twice other than the address changing from G2 to A2.
    here... =IF(A2="","","<ul><li>"&A2&"</li></ul>")
    Thank you so much

+ 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. Formula return empty if the cell is empty
    By iwanttoexcelinexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2022, 02:38 AM
  2. [SOLVED] Return formula when cell not empty
    By Mcfg007 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-05-2022, 09:11 AM
  3. [SOLVED] Excel formula to return last non-empty cell
    By IvanRama21 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-03-2020, 09:33 AM
  4. [SOLVED] Why won't a simple formula work in an empty cell
    By easygoingdave in forum Excel General
    Replies: 13
    Last Post: 06-16-2020, 08:18 AM
  5. [SOLVED] modifying this formula to return an empty cell
    By Outbacker in forum Excel General
    Replies: 3
    Last Post: 08-22-2006, 03:10 PM
  6. [SOLVED] return an EMPTY cell in an IF formula
    By JJN in forum Excel General
    Replies: 3
    Last Post: 02-10-2006, 12:20 PM
  7. formula/macro to return last non empty cell in a specified row
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2005, 10:32 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