I've got a large spreadsheet that I'm trying to optimise as it has over 12,000 lines of data, with in excess of 28 columns. It currently takes a significant amount of time to execute and I'm therefore starting to pare it down.
As part of this I've started looking at the formulae. there are several which are IF formula which return 1,0 instead of True,False - Like this
Would a Boolean result be quicker to run, and how would this be written? I'm aware you can put
-- in a formula, but I'm not sure of the exact specifics.