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

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

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

in A2 enter
=if(A1A5,"Your text","")

in A4 enter

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

if this helps please click yes thanks

"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

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

Thanks.

"Eduardo" wrote:

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

in A2 enter
=if(A1A5,"Your text","")

in A4 enter

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

if this helps please click yes thanks

"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

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

.

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 -