Jonathan Metzger 11.Feb.11 03:52 PM a Web browser 1-2-3 9.8 Windows XP
I saw syntax that looked like what I wanted months ago, but dunno if it was excel or lotus, and I can't find it again.
I have a very large block in a sheet that all has the same formula with only the references different. It's like 200 columns across and 200 rows down, it accounts for 40,000 out of the 67,000 formulas in the workbook and over half the file size.
It's of the format: @IF(longstatement=x,longstatement,"")
Repeating that longstatement twice in both the conditional and the true evaluation is a killer, and I was wondering if there was any sort of syntax like:
I would throw it into a custom function but I'm worried about the execution time cost.