View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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