Formula ...if AND ...many logics

[nt82]

Somehow this formula is not working..anything i need to change to work...

=If(AND(A1<A2,A2>A3,A3<A4,A4>A5,A5<A6,A6>A7),"Awesome"."Not Awesome")

basically i want to display "Awesome" ......if cell A1 < A2 and A2>A3 and A3<A4 and A4> A5 and A5<A6 and A6> A7

Thanks in advance

 

[Aladin Akyurek]

Somehow this formula is not working..anything i need to change to work...

=If(AND(A1<A2,A2>A3,A3<A4,A4>A5,A5<A6,A6>A7),"Awesome"."Not Awesome")

basically i want to display "Awesome" ......if cell A1 < A2 and A2>A3 and A3<A4 A4 and> A5 and A5<A6 and A6> A7

Thanks in advance

Just make sure: The conditional terms are...

A1 < A2

A2 > A3

A3 > A5

A5 > A7

Right?

 

[Peter_SSs]

Your formula didn't display properly but try just changing
"Awesome"."Not Awesome"
to
"Awesome","Not Awesome"

 

[nt82]

thanks mate