Copy down formula if cells on left non blank

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use if statement as a wrapper for you function

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month