i want to calculate 3 values in d15 col I have a formula =a1*a2*$a$3 and drag down upto d25
but in column d16 to m16 my formula changed to =$A$1*$B$1*D15 and drag to m16 which I changed manually.
from a1 to $a$1 first and then drag.
D15 E 15 F15
=A1*B1*$C$1 =$A$1*$B$1*D15 =$A$1*$B$1*E15
=A2*B2*$C$1
=A3*B3*$C$1
is there any formula to not to change this manually as my range of data is very large.
Bookmarks