Fill function

[Guest]

I am relatively new to excel and was wondering if it is possible to do the following.

I am trying to fill left with the following formua - =SUM((C7*D7)/100) what i want is to fill as =SUM((C7*E7)/100); =SUM((C7*F7)/100), so the C7 remain the constant when filling. Is this possible

Thanks for your help

 

[Vasant Nanavati]

Yes. Change C7 to $C7 in the original cell.

--

Vasant

I am relatively new to excel and was wondering if it is possible to do the following.

I am trying to fill left with the following formua - =SUM((C7*D7)/100)

what i want is to fill as =SUM((C7*E7)/100); =SUM((C7*F7)/100), so the C7
remain the constant when filling. Is this possible?

 

[Guest]

Thanks for your help!