Jun 10 2022 12:14 AM
Hello!
Question : Is anyone here know how to automatically copy a formula in excel from one cells to different cells ? Non-Adjacent cells.
I want automatically copy the formula from the Master.
I tried goggling it, but all answer I found is apply automatic in entire column. I don't want that because I have spacing in the table. Please help me.
See attached sample table.
Jun 10 2022 12:48 AM
There is an easy way. You could use the IF formula combined with "ISNUMBER", see formula below.
As you see, the blank columns has also got the forumla.
Forumla: =IF(AND(ISNUMBER(B2), ISNUMBER(C2)),B2*C2," ")
Use the forumla in one cell, CRTL Shift Down arrow to insert it in the row.
Jun 10 2022 01:01 AM
Jun 13 2022 12:20 AM
Well, you just have to create a real table. The column with the answer is a calculated column. You just have to insert the formula in the first cell, and it will automatically copy the the rest. If you change one of the formula's, all of them will change.