Excel - Copy down formula if cells non-blank

April 2018


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


You can use if statement as a wrapper for you function

, put your formula here)

Note that

Thanks to rizvisa1 for this tip on the forum.
Published by aakai1056. Latest update on November 17, 2011 at 10:00 AM by aakai1056.
This document, titled "Excel - Copy down formula if cells non-blank," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Display Formula in Cell
Calculate Time Between 2 Dates in Excel