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" 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" 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