Help

Re: Very simple Concatenate question I just can't figure out

Solved
Jump to Solution
424 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ryland-dxdl
5 - Automation Enthusiast
5 - Automation Enthusiast

I have two numerical values, A and B, that I am using to create a range field. Here is my current formula:

CONCATENATE({A}, "-", {B}). So far so good.
 
The tricky part is that not all of the entries have a B value, in which cases the result will look like {A}-. Ideally I would like it to just return the single value from A without the hyphen in this scenario.
 
I have tried using an IF to say IF(BLANK({B})) but here is where I get lost. 
 
Any advice is appreciated! I am very new to formulas... 
1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

A & 
IF(
  B,
  " - " & B
)

Screenshot 2024-07-28 at 1.09.14 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

A & 
IF(
  B,
  " - " & B
)

Screenshot 2024-07-28 at 1.09.14 PM.png

ryland-dxdl
5 - Automation Enthusiast
5 - Automation Enthusiast

An elegant solution that works perfectly, thank you so much!