Nesting Functions
 

I'm trying to combine AND, OR, and IF for the first time, and I'm getting
lost in the parentheses.

Here's the broader formula I'm trying to fill in:
=IF(AND(Fleet,Date Completed),1,0)

where Fleet needs to be filled in with:
OR($D8="HOS WH",$D8="HOS ENG")

and Date Completed needs to be filled in with:
AND($I8=40179,$I8<=40209)

I've tested the formulas for Fleet and Date Completed as their own logical
statements, and they both work. I can't get them combined in the larger
formula, though.

Any assistance would be appreciated!

Thanks...

Nesting Functions
 

=IF(AND(OR($D8="HOS WH",$D8="HOS ENG"),
AND($I8=40179,$I8<=40209)),1,0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Deanna" wrote:

I'm trying to combine AND, OR, and IF for the first time, and I'm getting
lost in the parentheses.

Here's the broader formula I'm trying to fill in:
=IF(AND(Fleet,Date Completed),1,0)

where Fleet needs to be filled in with:
OR($D8="HOS WH",$D8="HOS ENG")

and Date Completed needs to be filled in with:
AND($I8=40179,$I8<=40209)

I've tested the formulas for Fleet and Date Completed as their own logical
statements, and they both work. I can't get them combined in the larger
formula, though.

Any assistance would be appreciated!

Thanks...

Nesting Functions
 

You forgot to tell us what you tried as the combined formula, and in what
way it didn't work.

Presumably =IF(AND(OR($D8="HOS WH",$D8="HOS
ENG"),AND($I8=40179,$I8<=40209)),1,0)
or just
=--AND(OR($D8="HOS WH",$D8="HOS ENG"),AND($I8=40179,$I8<=40209)) ?
--
David Biddulph

Deanna wrote:
I'm trying to combine AND, OR, and IF for the first time, and I'm
getting lost in the parentheses.

Here's the broader formula I'm trying to fill in:
=IF(AND(Fleet,Date Completed),1,0)

where Fleet needs to be filled in with:
OR($D8="HOS WH",$D8="HOS ENG")

and Date Completed needs to be filled in with:
AND($I8=40179,$I8<=40209)

I've tested the formulas for Fleet and Date Completed as their own
logical statements, and they both work. I can't get them combined in
the larger formula, though.

Any assistance would be appreciated!

Thanks...

Nesting Functions
 

Ok, so when you put it that way!!! Thanks, I was making it way more
complicated than it needed to be...

"Luke M" wrote:

=IF(AND(OR($D8="HOS WH",$D8="HOS ENG"),
AND($I8=40179,$I8<=40209)),1,0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Deanna" wrote:

I'm trying to combine AND, OR, and IF for the first time, and I'm getting
lost in the parentheses.

Here's the broader formula I'm trying to fill in:
=IF(AND(Fleet,Date Completed),1,0)

where Fleet needs to be filled in with:
OR($D8="HOS WH",$D8="HOS ENG")

and Date Completed needs to be filled in with:
AND($I8=40179,$I8<=40209)

I've tested the formulas for Fleet and Date Completed as their own logical
statements, and they both work. I can't get them combined in the larger
formula, though.

Any assistance would be appreciated!

Thanks...