Help if()

F

fayez_MrExcel

Active Member
Joined
Oct 29, 2005
Messages
435
Office Version
  1. 365
Platform
  1. Windows
Please translate to proper formula:

If a1 = b2:b10 a1 = "True" if not "False"

Thanks
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
Norie

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,358
Office Version
  1. 365
Platform
  1. Windows
Please explain the logic/criteria.:)
 
Upvote 0
Scott Huish

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,961
Office Version
  1. 365
Platform
  1. Windows
Based on your other post. Is this what you mean?

=SUMIF($B$2;$B$10,A1,$F$2:$F$10)
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Conditional formatting column with multiple conditions
Replies
3
Views
543
DanteAmor
DanteAmor
K
  • Question
New book as CSV
Replies
1
Views
99
6StringJazzer
6StringJazzer
A
  • Solved
Need the Formula to be aligned
Replies
8
Views
120
Alex Blakenburg
A
G
  • Solved
Wanted to filter the data by column B (Emailid) and send email individually
Replies
5
Views
182
HaHoBe
HaHoBe
D
  • Question
Conditional Format cells with values that match the value of a cell within a range
Replies
7
Views
238
Fluff
Fluff

Forum statistics

Threads
1,191,691
Messages
5,988,110
Members
440,126
Latest member
duque00

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top