Help with a formula

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
=
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 *
 
hi
one way:
IF(COUNTIF('sheet1'!B11:B15,"A")=5,"X","")
(though not sure what you mean with 'X top')

Frank
 
Back
Top