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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF Formula 5
COPY BY MACRO DOWN TO LAST VALUE CELL IN COLUMN "A" 1
If a cell equals then macro 6
Help with modifying a formula. 7
Trying to Drag a Formula but it only Copies the First Cell 2
How to copy only to cells where there is data 4
I am trying to create a formula 1
How do I add a formula to a macro? 4

Back
Top