Copy down formula if cells on left non blank
Solved/Closed
Cochise
-
Mar 18, 2010 at 08:25 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 18, 2010 at 11:17 AM
rizvisa1 Posts 4478 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
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
Related:
- Copy down formula if cells on left non blank
- A little to the left free download - Download - Puzzle
- Left 4 dead 2 download - Download - Shooters
- Google sheet right to left - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 18, 2010 at 11:17 AM
Mar 18, 2010 at 11:17 AM
You can use if statement as a wrapper for you function
=IF(ISBLANK(H2), "", you formula here)
=IF(ISBLANK(H2), "", you formula here)