ExcelBanter - If........then......

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If........then...... (https://www.excelbanter.com/excel-discussion-misc-queries/246675-if-then.html)

nan4ca

If........then......

Is it possible to create a formula that if a condition is met in a cell, then
go to another cell and perform formula in that cell?

For Ex.: If the data in cell A1 is greater than or equal to 1, then the
formula in B1 is performed.

Ron Rosenfeld

If........then......

On Tue, 27 Oct 2009 09:20:02 -0700, nan4ca
wrote:

Is it possible to create a formula that if a condition is met in a cell, then
go to another cell and perform formula in that cell?

For Ex.: If the data in cell A1 is greater than or equal to 1, then the
formula in B1 is performed.

B1: =if(a1=1,"do formula","")

--ron

Jim Thomlinson

If........then......

=if(A1=1, "Your Calc Here", "")
--
HTH...

Jim Thomlinson

"nan4ca" wrote:

Is it possible to create a formula that if a condition is met in a cell, then
go to another cell and perform formula in that cell?

For Ex.: If the data in cell A1 is greater than or equal to 1, then the
formula in B1 is performed.

All times are GMT +1. The time now is 02:16 PM.