Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 27, 2024 10:38 AM
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...
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 27, 2024 10:09 PM
Does this look right? 
A &
IF(
B,
" - " & B
)
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 27, 2024 10:09 PM
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 28, 2024 08:00 AM
An elegant solution that works perfectly, thank you so much!
Reply
