IF Statement: Easy way to "reuse" the Test Condition?

[rbm]

Either I am blind and can not find my answer, or my want is unobtainable...

Excel 2003, IF statement formula.

I desire an easier way to code:
IF(testcondition<>some value, testcondition, something else)

where testcondition may be a very long statement that I do not wish to repeat within the IF statement twice.

Here is a smaller example:
If(Vlookup(bonus,bigarray,1)>1000,Vlookup(bonus,bigarray,1),"little")

Of course, I can throw the testcondition into a different cell range, and the above would become:
If(testcell>1000,testcell,"little")
but I am trying not to go that route.


Any words of wisdom out there?
Many Thanks,

 

[CWatts]

Set your test condition as a name.

Get your test condition and set it up as a stand alone formula. Copy the formula from the formula bar. Press CTRL-F3 to open the name manager. Make a new name and name it what you want, like TC or whatever and paste the formula you copied before in "Refers to" section.

Now if you take any cell and type =TestCondition you'll get the result and you can use it in the formula.

 

[rbm]

WOW! Absolutely fantastic and works perfectly. I use names all the time for other reasons, but never played with sticking a formula into the "refers to".

Many, many thanks. Lots of IF statements are going to become much more readable.

RBM