| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I use conditional formatting with formula and 3 poss resul | Excel Worksheet Functions | |||
| How do I refer to cell in another worksheet in a formula | Excel Worksheet Functions | |||
| I am getting formula displayed in some cells rather than the resul | Excel Worksheet Functions | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| how i can refer to cell in long formula go to another file | Excel Discussion (Misc queries) | |||
Linear Mode
