- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 30, 2024 07:19 AM
I am struggling to figure out an IF/THEN statement that includes an OR. Here is what I'm needing it to do.
I want to say "If there is anything populated in Column A, I want it to pull it into Column C. And if there is anything populated in Column B, I want it to pull into Column C, as well."
Here is my current formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 30, 2024 10:40 AM
It is easier to write these formulas if you share screen captures with sample data and sample results.
If you want the contents of {Column A} and {Column B}, you can just show both. If either is blank, it won't show anything. Note that if you want something other that a space between the column values, this particular formula will not work.
TRIM(CONCATENATE(
{Column A},
" ",
{Column B}
))
If you don't want to show {Column B} even if it has a value when there is no value for {Column A}, you can try something like this.
TRIM(CONCATENATE(
{Column A},
" ",
IF({Column A}, {Column B})
))
And another option, just for fun because there are so many ways to do things in code. This one will also only show {Column B} if {Column A} has a value. This one lets you put any characters you want between the two values.
IF(
AND(
{Column A},
{Column B}
)
{Column A} & ", " & {Column B},
{Column A}
)
