M
maryg
I need a formula that returns a "-" when the caluclation results in an error,
e.g., divide by zero, or when the value is too high, e.g., 500% change, or
too low, e.g., -500% change. I've managed to get the first part -- a "-"
when the calculation results in an error -- combining that with the other two
conditions is giving me fits, though.
e.g., divide by zero, or when the value is too high, e.g., 500% change, or
too low, e.g., -500% change. I've managed to get the first part -- a "-"
when the calculation results in an error -- combining that with the other two
conditions is giving me fits, though.