| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get excel to display the result of a formula i build?
Cell A1 is jan, B1 is feb, C1 is mar, etc
row 2 has values for each month cell C1 has a date 2/3/05 I want to sum the values for jan through X where X is month(C1) I built a text string I want Excel to evaluate as a formula. What's the function to do that? For instance, C2 might be ="="&char(64+month(C1))&2 I want this to resolve the formula =B2, not display "=B2" Any ideas? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula is entered but will not display result | Excel Worksheet Functions | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Threaded Mode
