If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set a constant multiplier in an equation?
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. |
#2
|
|||
|
|||
How do I set a constant multiplier in an equation?
As do all Excels.
-- HTH Bob "dalmar" wrote in message ... 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. |
#3
|
|||
|
|||
How do I set a constant multiplier in an equation?
So does the one you are using.
Regards, Fred "dalmar" wrote in message ... 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. |
#4
|
|||
|
|||
How do I set a constant multiplier in an equation?
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 |
Thread Tools | |
Display Modes | |
|
|