Home > Open Source Technology > Excel - Copy down formula if cells non-blank
Open Source Technology

Excel - Copy down formula if cells non-blank

On April 27,2022 by

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.

Leave a Reply

Your email address will not be published. Required fields are marked *