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 