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
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
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
its says there's a problem with this formula
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.
maybe it is G2 instead of G1? so... =IF(G2="","","<ul><li>"&[@Column1]&</li></ul>")
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.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
You may need to use semi-colons instead of commas, tryFormula:Please Login or Register to view this content.
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.
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
I missed a quote, tryFormula:Please Login or Register to view this content.
Hi mate,
Here's the sample file attached.
Thank you,
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>")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks