I'm working on an old spreadsheet that somebody else put together - they used "" in place of zero which means whenever the "" is used in a calculation, I end up with an error!
I thought an easy fix would be to use an IF function to replace the "" with a zero as in IF(A1="",0,A1)
However, this needs to be copied over to thousands of cells...
Will the addition of this many IF functions make the whole sheet sluggish to work with... or will it barely make any difference at all?
Thanks for any advice!
I thought an easy fix would be to use an IF function to replace the "" with a zero as in IF(A1="",0,A1)
However, this needs to be copied over to thousands of cells...
Will the addition of this many IF functions make the whole sheet sluggish to work with... or will it barely make any difference at all?
Thanks for any advice!