simple formula problem

  • Thread starter Thread starter smitty
  • Start date Start date
S

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.
 
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
 
Back
Top