How to calculate by keeping one cell constant

The cell which you want to keep constant should be wrapped in $ sign.

For example, your selling price is in cell E5 and if you want it to copy with E1 and drag it right

Then assuming, you want your formula at E2, then give like this

=E1*$E$5   and now if you drag/copy your cell E2 to your right side, then E5 will be constant.

i would like to calculate addition, subtract, multiply etc by keeping a particular value constant.

If you see the above, i have a cell selling price which will be constant and i would like to multiply above all cell by keeping it constant.

I put a formula on first cell of the sales column and copy formula for the remaining column, but it will not give the value shows error.

Can somebody advise how should i put a formula when i copy the formula remaining cell should calculate automatically 

Waiting for your reply.

Thanks

Abdul Qader

1. Add 2 named ranges for your selling price and your cost.

Please see:-

http://www.pierrefondes.com/

 - item 198.

2. Open my Workbook and inspect cells:-

B7 (to which I have give a name of Selling_Price)

C7 (to which I have given a name of Cost)

You can then use these named ranges in your calculations.

3. In my Workbook I have shown you how to set up a named range.