You could just have:

=IF(A1A5,A2,A4)

in C1.

Hope this helps.

Pete

On Feb 19, 3:29*pm, MAX wrote:
In this case I don't need A1=A5, does the formula remains the same?



"Pete_UK" wrote:
Put this in C1:

=IF(A1=A5,"not defined",IF(A1A5,A2,A4))

You didn't say what you want to happen if A1=A5.

Hope this helps.

Pete

On Feb 19, 2:22 pm, MAX wrote:
*I need a formula in cell C1 that when A1A5 it appears the text in
cell A2 and when A1<A5 it appears the text in cell A4.

Thanks in advance

.- Hide quoted text -

- Show quoted text -