Themba990
I have used the absolute reference however when i drag across to B3 then the formula becomes A2*$A$2 which then makes it zero.
I am looking for an equation that can display the answer of CDE (4) by A2(10) immediately B3 without having the zeroes in between.
Regards
Hi all
Please render some assistance here
On my attached file i have cells ABC merged into 1 and with a number 2 in it and the next cells CDE merged and the number 4 in it.
Cell A2 has number 10.
In cell A3 I put in a formula to multiply the 2 in the merged cells with the 10 in A2 however if I...