Shortening If-Then equations

[spacely]

Hi,

I have excel 2016. I wonder if there's a shorter way to do If-Then, to not repeat an emvedded equation twice, in one cell.


If (big-long-thing=-10000, then "", big-long-thing)

Want to avoid double length equations in excel, if I can.

Thanks!

 

[spacely]

I don't know why it wouldn't be robust enough to handle that. Maybe I need double precision. Maybe it's because in Formulas I have "enable iterative calculations". Weird.

 

[spacely]

Hmm, if I use a -1 as the trigger value instead of a large number like 10000000000, then it returns exactly what was input.

 

[FDibbins]

If you give realistic examples, we can give realistic suggestions - otherwise we are all just guessing