![]() |
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 |
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 |
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