I have an IF function that is returning an invalid parameter and I can’t figure out why. The IF function works properly if I replace the positive and negative conditions with “1” and “0”, respectively, and the CONCATENATE functions work properly when they are isolated. However, the function as a whole does not work for the positive result. It only works properly for the negative result. Can anyone point me in the right direction? The logic works, so it has to be a monday formula eccentricity, I think.
IF({s/h $} = "TBD", CONCATENATE("$", {Qty} * {Unit $}, " + s/h"), CONCATENATE("$", {Qty} * {Unit $} + {s/h $}))