ExcelBanter - How do I make a cell refrence another cell based on conditions?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I make a cell refrence another cell based on conditions? (https://www.excelbanter.com/excel-worksheet-functions/185280-how-do-i-make-cell-refrence-another-cell-based-conditions.html)

Carl

How do I make a cell refrence another cell based on conditions?

I am building a spread sheet to automatically select, and use, the correct
formula from a set of formulas based on inputs from 4 cells. 3 of these cells
contain validated data.

There is a total of 8 possible combination with the 3 cells, the forth cell
is a number that is used in the formulas.
Is this possible?

Gary''s Student

How do I make a cell refrence another cell based on conditions?

yes
--
Gary''s Student - gsnu200781

"Carl" wrote:

I am building a spread sheet to automatically select, and use, the correct
formula from a set of formulas based on inputs from 4 cells. 3 of these cells
contain validated data.

There is a total of 8 possible combination with the 3 cells, the forth cell
is a number that is used in the formulas.
Is this possible?

All times are GMT +1. The time now is 01:36 AM.