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

[nan4ca]

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]

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(A1>=1, "Your Calc Here", "")