Are there such things as variables within a formula?

[dbvl]

I hate repeating functions, particularly in formulas. Is there any way that I can avoid something like:

=IF( VLOOKUP(A1, B:B, 1, 0) > 10, VLOOKUP(A1, B:B, 1, 0) - 10, VLOOKUP(A1, B:B, 1, 0) )

[The above is just a simple example of the problem, and not a particular formula that I'm working with.]

[miguel-c]

Hi, you could define a name for a cell that contains the vlookup formula and then use it in your main formula:
=IF( name > 10, name - 10, name )

[dbvl]

Hi

Thanks

That sounds like it would work.