Hi Steve,

C6: =IF(AND(B6A5, B6B5, B6<B4, B6<B3, B6< B2, B6<B1),"FISH","")

If the conditions are not met an empty string is inserted in the cell,
the cell will never test as ISBLANK because it has a formula.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"contrarian" wrote ...

Okay, these are the simple conditions: (remember, we're starting in
cell C6)

(1) If B6 is greater than B5
(2) And B6 is also greater than A5 (next door)
(2) And B6 is also less than B4, less than B3, less than B2 and less
than B1

Then put the word "FISH" there.

I do not want it to put anything if those conditions are not met.

Does anyone know how to write the correct IF statement to do this?

(Please note: if it MUST say something when the conditions are not met,
I can live with that).