I find myself using the following syntax quite a bit, which is resulting in really long text strings that contain a lot of duplicative text...thinking there's got to be a way to shorten them:
Let's say column C has a really-long-formula, but I decide that if the result of the formula is negative, I simply want it to return 0. So what I've been doing for ages is modifying the formula to:
=IF((really-long-formula)<0 , 0 , really-long-formula)
When the formula's REALLY long, it seems really inefficient to make me type out the whole thing twice (and makes troubleshooting a PITA). Is there a better syntax I can use that will only require me to include the really long string once?
Let's say column C has a really-long-formula, but I decide that if the result of the formula is negative, I simply want it to return 0. So what I've been doing for ages is modifying the formula to:
=IF((really-long-formula)<0 , 0 , really-long-formula)
When the formula's REALLY long, it seems really inefficient to make me type out the whole thing twice (and makes troubleshooting a PITA). Is there a better syntax I can use that will only require me to include the really long string once?