Hi,
I have a formula which works fine when entered in to individual cells
=IF(D2=""," ",IF(C2="",A1,C2))
However, when you insert a new row in to google sheets it does also add the formula, therefore i tried the array function,
=arrayformula(IF(D2:D=""," ",IF(C2:C="",A1:A,C2:C))
This formula seems to give me a different answer to the original and i cannot work out why.
Thoughts?
I have a formula which works fine when entered in to individual cells
=IF(D2=""," ",IF(C2="",A1,C2))
However, when you insert a new row in to google sheets it does also add the formula, therefore i tried the array function,
=arrayformula(IF(D2:D=""," ",IF(C2:C="",A1:A,C2:C))
This formula seems to give me a different answer to the original and i cannot work out why.
Thoughts?
