| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with text values
Hi,
In cell A1 I have "3*50+1*120+2*25", with och without ", that doesn't matter in this case. The value in A1 is for display for the user, so that the user can see what values being summarized into cell A2. Now, for the question. How can a write a formula that makes a SUM in cell A2 that uses the values in cell A1? If I put a = in cell A1 Excel will make the calculation but if I want that value to show in cell A2? Best regards, /Combo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want a formula to ignore text values in cell references | New Users to Excel | |||
| formula mixed text and values | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Formula to sort text values with spaces | Excel Discussion (Misc queries) | |||
| How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
Threaded Mode
