Jul 13 2021 06:24 AM
Hello
I need to write formula in one cell (Like reference) and then use this formula in many different cells
So if I change the formula in the original cell, All other cells that use this formula should be changed
for example
A1: =IF C1="X", SUM(B5:B12), "No Value"
And I want to use the same formula in Cells (Z1), (Y1), (T1)
So if I change the formula to
A1: =IF C1="S", SUM(B1:B12), "Thank you"
All formula in Cells (Z1), (Y1), (T1) will change
Thank you
Jul 13 2021 06:33 AM
Jul 13 2021 06:39 AM
Jul 13 2021 06:46 AM
Jul 13 2021 06:47 AM - edited Jul 13 2021 06:50 AM
I need the formula from A1
One of the reasons for that is the H6 value is not the same in all sheets
Jul 13 2021 06:55 AM
Jul 13 2021 06:59 AM
Jul 13 2021 07:14 AM