| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Build excel formula using field values as text in the formula
Instead of writing the formula to add two cells as say, B4+B38 in Excel, I
want to build the formula using the contents on another cell, e.g. I've tried B4+"B"&(TEXT(B13,0)). The value of B13 is 38, therefore +"B"&(TEXT(B13,0)) equates to B38. That works fine. But if I combine it with B4 as above, the result is #VALUE! Any ideas on how I could get around this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Build excel formula using field values as text in the formula
You need INDIRECT, use:
=B4+INDIRECT("B"&B13) where B13 contains: 38 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "val kilbane" wrote: Instead of writing the formula to add two cells as say, B4+B38 in Excel, I want to build the formula using the contents on another cell, e.g. I've tried B4+"B"&(TEXT(B13,0)). The value of B13 is 38, therefore +"B"&(TEXT(B13,0)) equates to B38. That works fine. But if I combine it with B4 as above, the result is #VALUE! Any ideas on how I could get around this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Build excel formula using field values as text in the formula
You missed an "INDIRECT" Function in your formula
=B4+INDIRECT("B"&(TEXT(B13,0))) "val kilbane" wrote: Instead of writing the formula to add two cells as say, B4+B38 in Excel, I want to build the formula using the contents on another cell, e.g. I've tried B4+"B"&(TEXT(B13,0)). The value of B13 is 38, therefore +"B"&(TEXT(B13,0)) equates to B38. That works fine. But if I combine it with B4 as above, the result is #VALUE! Any ideas on how I could get around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| build external ref in formula from text? | Excel Discussion (Misc queries) | |||
| Build Formula | Excel Worksheet Functions | |||
| how do i get excel to display the result of a formula i build? | Excel Worksheet Functions | |||
| How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
| How would I build an "if" formula... | Excel Worksheet Functions | |||
Linear Mode
