Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1
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
 external usenet poster Posts: 9,221
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
 external usenet poster Posts: 3,718
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post klp2344 Excel Discussion (Misc queries) 1 January 6th 07 06:06 PM lynnc Excel Worksheet Functions 4 February 13th 06 11:24 PM Mike Excel Worksheet Functions 2 January 25th 06 07:25 AM nancy wilson Excel Worksheet Functions 0 September 18th 05 09:21 PM CMS1W8 Excel Worksheet Functions 1 January 28th 05 03:21 PM

All times are GMT +1. The time now is 10:13 PM.