if the result of formula <> x then result of formula

[AT--o]

Hi I need

=If(X+Y<>Z,X+Y,Z)

But without having to type X+Y again since my formula is very large. Using more than one cell is not an option.

Thank you all!

 

[shg]

Replace x, y, and z in your formula with references to the cells where those values are calculated.

 

[Weaver]

Not sure if this is actually possible, but I'd be interested to find out otherwise.

Having said that, why retype the x+y bit when you could probably copy/paste it?

 

[ukmikeb]

Hi

Possibly -

=X+Y

 

[AT--o]

Not sure if this is actually possible, but I'd be interested to find out otherwise.

Having said that, why retype the x+y bit when you could probably copy/paste it?

Lol, you are right. What I meant was I dont want excel to recalculate the formula.

 

[ukmikeb]

Hi

Do you really need the "IF"?

hth

Mike