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...
