Following picture is an example for fix a value while copying formula and drag it to down.In below picture I want to multiply all values of Qty with 100 for this I used formula =C5*D$4,Dollar sign fix the value and it can't change while copying cell.
No comments:
Post a Comment