Stav19 wrote:
Just out of interest, can you use "IF(AND)/(OR)" In the same formula
as a a normal if statement? I've tried before, but it never really
seemed to work. Could it work on the above as an example?

XL will nest ANDs, ORs, and NOTs as deep as I want to.
But I don't like very deep nesting.
My last line (a normal IF statement?) has an AND and an OR.

Dave D-C wrote:
Not nested; one level, but more than two conditions:
=IF(AND(B3+C3<1,D3="", E3=""),"NG","OK")

I don't think you want this here, but you can nest:
=IF(AND(OR(B3<1,C3<1),E3="", F3=""),"NG","OK")


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----