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