noreendeasy
New Member
- Joined
- Jul 16, 2014
- Messages
- 32
Hi there,
I have a spreadsheet that I would like to return 1. Text String based on which cells are entered and 2. Calculated Formula. Both are in different cells and I would like them merged on data is entered.
Its hard to explain but I'll show you what I mean
This starts blank until we get an exception and then we need to figure out whats causing it
<TBODY>
</TBODY>So to explain above what I need is to formula the Narrative:
The user pastes values in B which calculates C.
The Narrative needs to return whats in A and C (as above) based on what the user pastes in B.
So if this changed to:
<TBODY>
</TBODY>
The Narrative would need to be automatically updated to using a formula : Is this possible?
<TBODY>
</TBODY>
I have a spreadsheet that I would like to return 1. Text String based on which cells are entered and 2. Calculated Formula. Both are in different cells and I would like them merged on data is entered.
Its hard to explain but I'll show you what I mean
This starts blank until we get an exception and then we need to figure out whats causing it
A</SPAN> | B</SPAN> | C</SPAN> | |
1</SPAN> | Movement</SPAN> | Movement Value</SPAN> | BPS</SPAN> |
2</SPAN> | Net Gain/Loss </SPAN> | 0.16</SPAN> | 0.02</SPAN> |
3</SPAN> | Income</SPAN> | ||
4</SPAN> | Forward Contracts</SPAN> | 0.1</SPAN> | 0.01</SPAN> |
5</SPAN> | Total</SPAN> | 0.03</SPAN> | |
6</SPAN> | Narrative:</SPAN> | Main Driver of Movement is _____ in this case (A Value) Net Gain/Loss of (C Value) ____ .01 and Forward Contracts of .01 giving an overall movement of _____.03 (C Total)</SPAN> |
<TBODY>
</TBODY>
The user pastes values in B which calculates C.
The Narrative needs to return whats in A and C (as above) based on what the user pastes in B.
So if this changed to:
A</SPAN> | B</SPAN> | C</SPAN> | |
1</SPAN> | Movement</SPAN> | Movement Value</SPAN> | BPS</SPAN> |
2</SPAN> | Net Gain/Loss </SPAN> | ||
3</SPAN> | Income</SPAN> | ||
4</SPAN> | Forward Contracts</SPAN> | 0.2</SPAN> | 0.03</SPAN> |
5</SPAN> | Total</SPAN> | 0.03</SPAN> | |
</SPAN> | </SPAN> |
<TBODY>
</TBODY>
The Narrative would need to be automatically updated to using a formula : Is this possible?
6</SPAN> | Narrative:</SPAN> | Main Driver of Movement is Income of .03 giving an overall total of .03 </SPAN> |
<TBODY>
</TBODY>
Last edited: