Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting Functions | Excel Worksheet Functions | |||
Nesting if Functions | New Users to Excel | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
nesting functions | Excel Worksheet Functions | |||
Nesting Functions | Excel Worksheet Functions |