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

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

Copy down formula if cells on left non blank
A little to the left free download mac - Download - Puzzle
Left 4 dead 2 download - Download - Shooters
Google sheet right to left - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 18, 2010 at 11:17 AM

You can use if statement as a wrapper for you function

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

help me to add particular cells

Compare values in two columns and return the value from third

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!