Copy down formula if cells on left non blank

Solved/Closed
Cochise - Mar 18, 2010 at 08:25 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 18, 2010 at 11:17 AM
Hi,

I need code to copy down a formula from R2 to R3, R4 , R5 etc only if H3, H4, H5 etc is nonblank.

I also need to copy formulae from U2:CY2 to U3:CY3, U4:CY4 etc only if S3, S4 etc =1

Many thanks in advance

Cochise

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 18, 2010 at 11:17 AM
You can use if statement as a wrapper for you function

=IF(ISBLANK(H2), "", you formula here)
1