Help with a formula

[Brian W]

Is there a formula that can do this- On worksheet 2 I want
an X to appear in a cell, let's say b2 when on worksheet 1
Cells b11:b14 all contain the letter A (which appears as a
checkmark in the Martell font). Is there also a way to
keep b2 on worksheet 1 blank when only b11:b13 contain the
letter A?

Thanks
Brian

 

[A.W.J. Ales]

Gary,

IF(AND(Sheet1!B11="A",Sheet1!B12="A",Sheet1!B13="A",Sheet1!B14<>"A"),"",
IF(AND(Sheet1!B11="A",Sheet1!B12="A",Sheet1!B13="A",Sheet1!B14="A"), formula
if all "A" 's , Formula if both sets aren't true) )

NB In the earlier question you spoke of B11:B15 on sheet 1 ; the second
question only B11:B14.

You will have to adapt this formula if indeed B11:B15 is mentioned.


--
Regards,
Auk Ales

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