Help with a formula

[Brian]

Is there some kind of IF or any other kind of formula that
can to this- In worksheet 2 I want an X top appear in a
cell when B11:B15 from worksheet 1 all contain the letter A
(which would appear as a checkmark using the martell font).

Thanks for your help
Brian

 

[A.W.J. Ales]

=
IF(AND(Sheet1!B11="A",Sheet1!B12="A",Sheet1!B13="A",Sheet1!B14="A",Sheet1!B1
5="A"), formula if true , formula if false )
--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Frank Kabel]

hi
one way:
IF(COUNTIF('sheet1'!B11:B15,"A")=5,"X","")
(though not sure what you mean with 'X top')

Frank

 

[Guest]

Thanks!! I'lll try that. I meant the "X top" to say "X to".
Sorry