How do I set a constant multiplier in an equation?
in [Functions]
|
Prev: How can I merge unprotected cells in a protected worksheet?
Next: Drop Down Menu AutoPopulate Contact Info?
From: dalmar on 27 Apr 2010 18:40 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.
From: Bob Phillips on 27 Apr 2010 18:59 As do all Excels. -- HTH Bob "dalmar" <dalmar(a)discussions.microsoft.com> wrote in message news:8E736A76-E4B2-4C89-A29B-92657638C13D(a)microsoft.com... > 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.
From: Fred Smith on 27 Apr 2010 20:04 So does the one you are using. Regards, Fred "dalmar" <dalmar(a)discussions.microsoft.com> wrote in message news:8E736A76-E4B2-4C89-A29B-92657638C13D(a)microsoft.com... > 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.
From: Dave Peterson on 27 Apr 2010 20:31
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 dalmar wrote: > > 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. -- Dave Peterson |