simple formula problem

[smitty]

I am probably approaching this all wrong...

A B C D
9 7 5 6

My formula is as follows:

=if(A1>B1,B1>C1,C1<D1,A10,"")

I would like to print the value in cell A10 if A1>B1 and
B1>C1 and C1<D1 however the above formula is not working
for me. Any thoughts? Thanks.

 

[Andy B]

Hi

Try this:
=IF(AND(A1>B1,B1>C1,C1<D1),A10,"")

 

[Peo Sjoblom]

Try

=IF(AND(A1>B1,B1>C1,C1<D1),A10,"")

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom