Hi David,
thanks, i missed the T3 by K3.

regards,
driller
--
*****
birds of the same feather flock together..



"David Biddulph" wrote:

=IF(AND($I$5="",$J$5=""),IF(OR($G$5=K3,$G$5<=K2),1 ,IF(OR($H$5=K3,$H$5<=K2),1,"")),IF(OR($I$5=T3,$I$5 <=K2),1,IF(OR($J$5=K3,$J$5<=K2),1,"")))
or simplify it to
=IF(AND($I$5="",$J$5=""),IF(OR($G$5=K3,$G$5<=K2,$H $5=K3,$H$5<=K2),1,""),IF(OR($I$5=T3,$I$5<=K2,$J$5= K3,$J$5<=K2),1,""))
--
David Biddulph

"Gayla" wrote in message
...
Here are the formulas I am trying to put together into one formula but
cannot
seem to get it right.

IF((AND($I$5="",$J$5="") IF TRUE THEN DO THE FOLLOWING CALCULATION:

SEE IF ONE OF THE FOLLOWING APPLY:
OR($G$5=K3,$G$5<=K2),1,""), OR($H$5=K3,$H$5<=K2),1,"")

IF FALSE DO THE FOLLOWING:

SEE IF ONE OF THE FOLLOWING APPLY:
OR($I$5=T3,$I$5<=K2),1,""), OR($J$5=K3,$J$5<=K2),1,"")

Any help will be appreciated.