In a monthly report I have a requirement to track a certain type of day (
AE10 ) that is dependant upon two other day group conditions ( L10:P10, and
AB10 ). The answer cell ( AE10 ) should indicate either a 0 or 1.

L10:P10 ( ie. =SUM 3.8 hrs )
AB10 ( Control Check box, Linked to AI10 )
AH10 ( =IFAI10.1.0 )
AE10 ( Should be 0 or 1, depending upon L10:P10, and AB10 )

If L10:P10 has accumulated hours, and AB10 is Contrtol Box Checked (1),
then AE10 =1.
If L10:p10 has no accumulated hours, and AB10 is Control Box Checked (1),
then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is not Control Box Checked
(0), then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is Not Control Box Checked
(0), then AE10=0.

Help is appreciated! Thanks

Assuming you're using the Check box from the Forms Toolbar, here's some
options to play with:

As it stands, with your set-up as described,

Put in AE10, either:
=IF(AND(SUM(L10:P10)<0,AH10=1),1,0)
or
=IF((SUM(L10:P10)<0)*(AH10=1),1,0)

But I think we can dispense with the formula in AH10,
and read the checkbox's link cell AI10 directly

In which case, we could try instead in AE10, either:
=IF(AND(SUM(L10:P10)<0,AI10),1,0)
or
=IF((SUM(L10:P10)<0)*AI10,1,0)

(the formula in AH10 can be deleted)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kane" wrote in message
...

In a monthly report I have a requirement to track a certain type of day (
AE10 ) that is dependant upon two other day group conditions ( L10:P10,
and
AB10 ). The answer cell ( AE10 ) should indicate either a 0 or 1.

L10:P10 ( ie. =SUM 3.8 hrs )
AB10 ( Control Check box, Linked to AI10 )
AH10 ( =IFAI10.1.0 )
AE10 ( Should be 0 or 1, depending upon L10:P10, and AB10 )

If L10:P10 has accumulated hours, and AB10 is Contrtol Box Checked (1),
then AE10 =1.
If L10:p10 has no accumulated hours, and AB10 is Control Box Checked (1),
then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is not Control Box Checked
(0), then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is Not Control Box Checked
(0), then AE10=0.

Help is appreciated! Thanks

Thanks ... Your info was most helpful. I had to change it slightly as I had
given all of the correct parameters. It works!

.... Kane

"Max" wrote:

Assuming you're using the Check box from the Forms Toolbar, here's some
options to play with:

As it stands, with your set-up as described,

Put in AE10, either:
=IF(AND(SUM(L10:P10)<0,AH10=1),1,0)
or
=IF((SUM(L10:P10)<0)*(AH10=1),1,0)

But I think we can dispense with the formula in AH10,
and read the checkbox's link cell AI10 directly

In which case, we could try instead in AE10, either:
=IF(AND(SUM(L10:P10)<0,AI10),1,0)
or
=IF((SUM(L10:P10)<0)*AI10,1,0)

(the formula in AH10 can be deleted)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kane" wrote in message
...

In a monthly report I have a requirement to track a certain type of day (
AE10 ) that is dependant upon two other day group conditions ( L10:P10,
and
AB10 ). The answer cell ( AE10 ) should indicate either a 0 or 1.

L10:P10 ( ie. =SUM 3.8 hrs )
AB10 ( Control Check box, Linked to AI10 )
AH10 ( =IFAI10.1.0 )
AE10 ( Should be 0 or 1, depending upon L10:P10, and AB10 )

If L10:P10 has accumulated hours, and AB10 is Contrtol Box Checked (1),
then AE10 =1.
If L10:p10 has no accumulated hours, and AB10 is Control Box Checked (1),
then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is not Control Box Checked
(0), then AE10=0.
If L10:P10 has no accumulated hours, and AB10 is Not Control Box Checked
(0), then AE10=0.

Help is appreciated! Thanks

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

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

Admit it's a bit confusing, Kane <g. Anyway, here's one deep guess at
interpreting your set-up and what you're after

Put in AQ10:
=IF(AND(SUM(D10,K10,L10:P10)=5,NOT(AI10)),0,
IF(AND(SUM(D10,K10,L10:P10)=0,NOT(AI10)),0,1))

Test out the output in AQ10 with all the scenarios
(Lightly tested here, it seems to function as it should)

Some clarifications:
I've presumed the checkbox's link cell is still AI10, and that you want to
monitor cells: D10, K10, and L10:P10. Following through from your orig.
post, I've read your description of: "L10:P10" to mean *all* the cells
between L10 to P10, inclusive. If this is not the case and you actually
mean: L10, P10 only, then just change the part:

SUM(D10,K10,L10:P10)

to

SUM(D10,K10,L10,P10)

in AQ10's formula

And I've also disregarded your line:

1. If Start and Stop hours are entered in B10 & C10, with results in I10;

as cells B10, C10 and I10 don't seem to figure in the scenario details which
follow thereafter ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kane" wrote in message
...
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 ?