fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 437
- Office Version
- 365
- Platform
- Windows
Please translate to proper formula:
If a1 = b2:b10 a1 = "True" if not "False"
Thanks
If a1 = b2:b10 a1 = "True" if not "False"
Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help if()
- Thread starter fayez_MrExcel
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,330
- Office Version
- 365
- Platform
- Windows
=COUNTIF($B$2:$B$10,A1)>0
Upvote
0
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,330
- Office Version
- 365
- Platform
- Windows
Based on your other post. Is this what you mean?
=SUMIF($B$2;$B$10,A1,$F$2:$F$10)
=SUMIF($B$2;$B$10,A1,$F$2:$F$10)
Upvote
0
Similar threads
