Sunday, April 9, 2017

yogi_Setup Array Formula For Computed Column Based On 'OR' Criteria

Google Spreadsheet   Post  #2148
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-09-2017
question by HelloHey:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/KjrrSY7qQ4I;context-place=mydiscussions
Automatically expand formula to new rows. How?
Hi,

How do I apply a formula to ALL cells in a column? Alternatively, how do I automatically expand a formula to new cells?

I want to expand this:

=IF(OR(F27="USA",F27="Canada"), H27, 0 )

Thanks!