ExcelBanter - Overriding formula

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

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

- - Overriding formula (https://www.excelbanter.com/excel-worksheet-functions/231345-overriding-formula.html)

KANDLEZ[_2_]

Overriding formula

I have a if formula in a cell, but need to override it from another cell.
what formula can I use.
--

David Biddulph[_2_]

Overriding formula

=IF(override_cell="Yes","Value overridden",your_formula)
--
David Biddulph

KANDLEZ wrote:
I have a if formula in a cell, but need to override it from another
cell. what formula can I use.

Gord Dibben

Overriding formula

Formulas return results to the cell in which they are written.

Please explain in more detail what you want to do.

Post the formula you have and which cell it is in.

Post the address of the "another cell"

Gord Dibben MS Excel MVP

On Tue, 19 May 2009 13:14:01 -0700, KANDLEZ
wrote:

I have a if formula in a cell, but need to override it from another cell.
what formula can I use.

All times are GMT +1. The time now is 12:00 PM.