hamburg18w
Technical User
Can you help me build the following formula:
if f6:j6 =
Either: "Of" or "Hm" or "Grp" or "Ph" =
Result: Yes
if f6:j6 =
Either: "Of" or "Hm" or "Grp" or "Ph" =
Result: Yes
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If with multiple criteria 1
- Thread starter hamburg18w
- Start date
- Status
SkipVought
Programmer
Hi,
Use the COUNTIFS() function. If the function returns a value greater than 0, you meet your requirement.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
Use the COUNTIFS() function. If the function returns a value greater than 0, you meet your requirement.
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]-
1
- #3
- Thread starter
- #4
hamburg18w
Technical User
Thank you for the help. It worked. I really appreciate the quick response.
Juan
Juan
- Status
Similar threads