Are Boolean expressions fast evaluated in google sheet formulas?

by Andrej Adamenko   Last Updated March 20, 2019 17:03 PM

Suppose I have the following expression repeated in a long column:

=IF(OR($U2=""; COUNT(aHugeRange)=0); ""; SUM(aHugeRange))

I would like to avoid performing COUNT() and SUM() as much as possible to increase performance.

Will COUNT(), SUM() be ever executed for the rows where $U is empty?

Will the following modification work differently?

=IF($U2=""; ""; IF(COUNT(aHugeRange)=0; ""; SUM(aHugeRange)))


Related Questions


Updated March 22, 2019 15:03 PM

Updated July 19, 2018 01:03 AM

Updated April 12, 2019 01:03 AM

Updated January 18, 2019 09:03 AM

Updated February 06, 2019 12:03 PM