Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |