Copy a formula to 15 pages

G

Guest

I would like to copy the formulas in Columns C to H to the next 15 pages, but
only if there is a number supplied in Column B. If Column B is empty, I
would like C to H to be empty. Is this possible? Thank you.
 
G

Guest

Why not use an If statement in the formula?

Such as...

=IF(B1="", "", {The formula you currently have})

Put this into all of the cells and then the formula will exist but will be
empty if B is empty.

HTH.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If andf countif 1
Excel Countifs/Sumproduct with mutil Or statement 3
SUM - IF - AND 7
Excel Subtracting multiple columns from another column 3
Excel sum if and closed workbooks 2
Excel How to calculate in excel number of open actions that expired (older then today) 0
Excel Help to copy information from one row at a time to another sheet 1
Formulae needed 1

Top