ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating a cell within a cell (https://www.excelbanter.com/excel-discussion-misc-queries/124880-calculating-cell-within-cell.html)

navin

Calculating a cell within a cell
 
Hi,

I wonder, if this is possible.


I have three diff formulas in three cells, like below.


B1: =formula 1
B2: =formula 2
B3: =formula 3


In cell A1, i have a list of dates. now when i select a date eg. 1,
then the formula in A2, should go to cell B1 and then again calculate
the formula entered within cell B1.


Please help. Thanks in advance.


Regards,
Navin


Bernard Liengme

Calculating a cell within a cell
 
Mutliposting is considered an evil. Multiposting can result in someone
spending time answering a question that is already answered. Anyway, most of
us read all the main newsgroups. I suspect your question in the other
newsgroup was left unanswered because it was too hard to follow.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"navin" wrote in message
ps.com...
Hi,

I wonder, if this is possible.


I have three diff formulas in three cells, like below.


B1: =formula 1
B2: =formula 2
B3: =formula 3


In cell A1, i have a list of dates. now when i select a date eg. 1,
then the formula in A2, should go to cell B1 and then again calculate
the formula entered within cell B1.


Please help. Thanks in advance.


Regards,
Navin




navin

Calculating a cell within a cell
 
Apologise for this. Issue was very urgent. Will take in future.

Thanks


Bernard Liengme wrote:
Mutliposting is considered an evil. Multiposting can result in someone
spending time answering a question that is already answered. Anyway, most of
us read all the main newsgroups. I suspect your question in the other
newsgroup was left unanswered because it was too hard to follow.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"navin" wrote in message
ps.com...
Hi,

I wonder, if this is possible.


I have three diff formulas in three cells, like below.


B1: =formula 1
B2: =formula 2
B3: =formula 3


In cell A1, i have a list of dates. now when i select a date eg. 1,
then the formula in A2, should go to cell B1 and then again calculate
the formula entered within cell B1.


Please help. Thanks in advance.


Regards,
Navin




All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com