Transposing Multiple Cell References to Multiple Values (NOT t
PPS Sorry, I realise I am now starting to not explain myself properly,
because in my original post I said I did not want the cell to show 1000.
What I would like is:
Cell to show 1000
Formula line to show =700+300 (when the cell is clicked on)
It may be necessary for a two part process (which I'm happy to deal with)
A) Formula line is = H11 + G20 / Cell shows 1000
By transposing (somehow) cell references to values
B) Formula line is = 700 + 300 / Cell shows 1000
At the moment with the ampersand solution I have:
Formula line is ="="&H11&"+"&G20 / Cell shows = 700+300 (ie not a value)
Does this make it clearer?
Thanks for any additional suggestions
"RagDyer" wrote:
Try this:
="="&H11&"+"&G20
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LinLin" wrote in message
...
Hi Everyone
Sometimes it is useful for me to show that a cell contains a string of
numbers which make up a total.
For instance, I would show in a Cell that the total you see ($1000) is
made
up of $700 + $300
Sometimes, those individual amounts come from different sources / links.
So, (as an example) H11 ($700) plus G20 ($300) = $1000
In the cell it shows = H11 + G20
Is there any function which will transpose those cell references to the
amounts they represent WITHOUT summing them in the cell?
IE I would like to get = H11 + G20 to show = 700 + 300
NOT =1000
Does anyone have any ideas?
This kind of thing is very useful for reconciliations etc.
thanks!
|