26th April 2006, 08:17 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by Twodogs
=IF(AND(O7<2.5,Q7<35.2,U7>0),1,0)
I just tried the above formula but although the three columns meet criteria I still get 0 rather than a 1 Have I balls up somewhere? Twodogs
|
See my previous response, there is a formula shown there that I use in one of my programs. |