Formula

[MAX]

I need a formula in cell C1 that when A1>A5 it appears the text in
cell A2 and when A1<A5 it appears the text in cell A4.

Thanks in advance

 

[Pete_UK]

Put this in C1:

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

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

Hope this helps.

Pete

 

[Eduardo]

Hi,
what happens in A2 if A1<A5??, I assume you want blank

in A2 enter
=if(A1>A5,"Your text","")

in A4 enter

=if(A1<A5,"Your text","")

if this helps please click yes thanks

 

[MAX]

In A2 I have the name Joe and in A4 I have the name Tony, so when A1>A5 I
want Joe in C1 and when A1<A5 I want Tony in C1.

Thanks.

 

[MAX]

In this case I don't need A1=A5, does the formula remains the same?

 

[Pete_UK]

You could just have:

=IF(A1>A5,A2,A4)

in C1.

Hope this helps.

Pete