I managed to write a grammatically correct formula that I thought encompassed my query, but I'm getting a #ERROR! on the output.My aim is to add a conditional statement to the formula @AirOps was kind enough to format for me -SUBSTITUTE(IF(ISBN13!=""...
Hi All,This is hopefully a basic and quick fix. I've got a concatenate formula that works beautifully to join a suffix to a base number, but part of the suffix is a price, and I need to have the "." removed from the string. Here's what I have so far:...
Unfortunately, it's still returning #ERROR! for me. Based on what you got from your test, it should be right. Could it be the source string? The US Price is manually entered, formatted as currency, and the ISBN13 is an output from another formula.
Related to this formula, I want to craft an IF statement to add a character to the output under specific conditions, but I'm not sure how to write it since the condition is based on character count.Essentially, if {US Price} is less than 4 digits, I ...
Thank you so much! I was trying to add Substitution to the end of the formula, rather than wrapping it around the concatenate. It'll probably be a bit before I truly understand the syntax, but thank you for the help!
