MAx.. Not sure if I can use this route again, but here goes!
I now have a real problem that expands upon this scenario. I changed the
formula to read < =If(AND(SUM(L10:P10)=0,AI10),1,0) , as I was incorrect in
stating condition 2. Condition 2 should have been < L10:P10 has no
accumulated hours( 0.0), and AB10 is checked (1), then AE10=1.

To start over might be better. We want to record chargeable "Standby" time
dependant upon the# of truck types ( dependant upon weight ) driven ( max of
three types ). A selection is made ( one of 7 combinations ) using Control
Box,"CheckBox" (1 or 0) and supporting cell (format control, checkbox)
indicating the time ( 0.0 hours).
If there is no actual time (hours) entered , & or hours driven distribution,
then Standard "StandBy" hours( 1=7.8 , 2=3.9 each, 3=2.6 hours) are entered
in the max of three designated truck type columns..
I changed your formula to< =IF(AND(SUM(D10:K10:L10:P10)=0,Al10),1,0) and
it worked fine. Then, the rules changed and here are the real scenario's!
**** 4 Conditions
1. If Start and Stop hours are entered in B10 & C10, with results in I10;
If < D10:K10:L10:P10 HAS actual hours accumulated (5.0); and <
AB10 is Control box "Checked" (1), then < AQ10=1
2. If < D10:K10:L10:P10 has NO accumulated hours (0.0) entered; and <
AB10 is control box checked (1); then < AQ10=1
3.If D10:K10:L10:P10 has accumulated hours (5.0), and < AB10 is NOT
checked (0), then < AQ10=0 .
4, If < D10:K10:L10:P10 has NO accumulated hours (0.), and < AB10 is NOT
checked; then < AQ10=0

The time distribution determined by the number of truck types is based on
7.8 hours per day,and is selectable using a control check box.

If 1, then AM54,AM55, AM56 =7.8 hours
If 2, then AP54, AP55, AP56=7.8/2=3.9 hours
If 3, then AS54=7.8/3=2.6 hours

I hope that this makes some kind of sence!?

Should I re-post this ?


"Max" wrote:

Glad it worked, Kane !
You're welcome, and thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kane" wrote in message
...
Thanks ... Your info was most helpful. I had to change it slightly as I
had
given all of the correct parameters. It works!

... Kane