If a formula is too long then refer to the cell after a TRUE resul
 

I have a huge formula that I use to accrue vacation time.

Can I have a formula execute that is in say H2 if the result in G2 is TRUE?
Basically if G2 is =140 then do H2. Is this do-able???

If a formula is too long then refer to the cell after a TRUE resul
 

H2 is going to calculate regardless of the values of the cells around it. The
only thing you cna do is to use an if statement to make H2 appear as if
nothing is calculated. In H2 the formula would be something like

=if(G2<140, "", "Do Your Stuff")

--
HTH...

Jim Thomlinson


"naiveprogrammer" wrote:

I have a huge formula that I use to accrue vacation time.

Can I have a formula execute that is in say H2 if the result in G2 is TRUE?
Basically if G2 is =140 then do H2. Is this do-able???