Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace "Cell based" formulas with "word-based" formulas
Not sure if I am doing this correctly, but, I have a small group of
accounting information, and the fomulas I have in place, I need to replace them with names. So instead of =A4-A5, it has to be =(€˜Selling price €˜Proposal B) €“ (€˜variable cost €˜Proposal B) How do I make this change?? I am using Excel 2007 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace "Cell based" formulas with "word-based" formulas
Formulas/ Name Manager/ Define Name, then Use in Formula
-- David Biddulph Brian wrote: Not sure if I am doing this correctly, but, I have a small group of accounting information, and the fomulas I have in place, I need to replace them with names. So instead of =A4-A5, it has to be =('Selling price' 'Proposal B') - ('variable cost' 'Proposal B') How do I make this change?? I am using Excel 2007 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace "Cell based" formulas with "word-based" formulas
Give the cells defined names.
Select cell A4 In the name box, that space immediately above column A, type in: Selling_Price_Proposal_B Hit Enter Select cell A5 In the name box type: Variable_Cost_Proposal_B Hit Enter You can't have spaces in those names so I used the underscore to replace them. Then your formula will be: =Selling_Price_Proposal_B-Variable_Cost_Proposal_B If you ask me, which you didn't, it's a lot easier to use: =A4-A5 <bg -- Biff Microsoft Excel MVP "Brian" wrote in message ... Not sure if I am doing this correctly, but, I have a small group of accounting information, and the fomulas I have in place, I need to replace them with names. So instead of =A4-A5, it has to be =('Selling price' 'Proposal B') - ('variable cost' 'Proposal B') How do I make this change?? I am using Excel 2007 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace "Cell based" formulas with "word-based" formulas
Instructions for Excel 2003 and earlier.
Assuming you have named A4 and A5 using InsertNameDefine Click on the cell with the formula and InsertNamesApply. CTRL + Click to select the names and OK Excel 2007 Click on the cell with the formula and on Formula TabUse In Formula Gord Dibben MS Excel MVP On Mon, 19 Oct 2009 13:56:01 -0700, Brian wrote: Not sure if I am doing this correctly, but, I have a small group of accounting information, and the fomulas I have in place, I need to replace them with names. So instead of =A4-A5, it has to be =(‘Selling price’ ‘Proposal B’) – (‘variable cost’ ‘Proposal B’) How do I make this change?? I am using Excel 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Formatting "IF" response based on "OR" function | Excel Worksheet Functions | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) |