How do I set a constant multiplier in an equation?

  • Thread starter Thread starter dalmar
  • Start date Start date
D

dalmar

When using excel to make a spread sheet with list prices, net prices with
constant multipkiers, How do I set a constant multiplier in an equation? The
old excel used the $ befor the cell to do this.
 
If you're looking at R1C1 reference style (you'll see numbers where the column
letters used to be), you can use:

=R1C1*(yourexpression here)
(R1C1 is the same as A1 -- just different style)

But it would be easiest to change to the reference style you're used to.

In xl2003 menus:
Tools|Options|General tab
uncheck R1C1 Reference style

In xl2007:
Office button|Excel Options|Formulas|Working with formulas
uncheck R1C1 Reference style
 
Back
Top