AND statement with adjacent cells

In the example attached I am trying to create a statement that will return true with the following conditions: a cell in E:E contains the text “fault 1” and the figure in the cell to the right of that cell is greater than 6.

So in the attached example cells E1 and F1 would trigger the statement as true as both these conditions are met but if I were to use the same formula for “fault 2” then it would be false as there are no adjacent cells containing a number over 6.

Hope this makes some sense to anybody?

I have updated to 2007 and have not updated my profile will do that now! Seems to be working perfectly thanks but would it be of any detriment to use:

Please Login or Register  to view this content.

Ok I may try and use a range then the workbook is starting to feel a little sluggish and I still have a lot left to add. Thanks for your help.

Bump, anybody?

So sorry, I uploaded the wrong attachment! I had 2 files on my desktop with the same name but different extensions and I stupidly uploaded the wrong one!

I have amended my post to include the correct example now.

Thanks once again, that seems to have done the trick.

Would anybody know if it is possible to manipulate this formula to actually count the number of instances that this is true?

Currently it will show TRUE if there are any instances within the range where the criteria are met, is it possible to use this formula to count them?

Ok think I may have worked this out myself I just needed to remove the >0