When I have a very heavy formula and before the whole formula I am adding an IF formula and if it's true and it will get the result.
Will it make my formula less heavy? I mean will it not conitnue calculating the other conditions then?
Example:
The current formula:
=IF(something very complicated, bla bla, if(complicated.... and etc.)
The optimized formula:
=IF(B2="","V",the current formula)
When the first condition is true (B2=""), will it not continue the calculation and thus the formula will be calculated quicker?
I hope it is clear what I wanted to say
Thanks
Bookmarks