Excel - Copy down formula if cells non-blank

December 2016




Issue


I need code to copy down a formula from R2 to R3, R4, R5 etc only if H3, H4, H5 etc is non-blank.
  • I also need to copy formulae from U2:CY2 to U3:CY3, U4:CY4 etc only if S3, S4 =1

Solution


You can use if statement as a wrapper for you function

=IF(ISBLANK(H2), ""
, put your formula here)

Note that


Thanks to rizvisa1 for this tip on the forum.

Related :

This document entitled « Excel - Copy down formula if cells non-blank » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.