Completed

IF-AND-OR Excel Formula working for some cells but not others

Hi - I have an IF-AND-OR Excel formula that is working for some cells, but not others.

Here is the formula that works:

=IF(AND(OR($B8=1, $B8=2), $D8="F", $E8="L"), $A8)

B8 can have a value of 1 thru 9; D8 can have a value of "B", "L", "DF", or "F"; and E8 can have a value of "S", "M", or "L". If this combination of scenarios occurs, then show the value of A8.

Here is the formula that does not work:

=IF(AND(OR($B2=3, $B2=4), $D2="L", $E2="M"), $A2)

B2 can have a value of 1 thru 9; D2 can have a value of "B", "L", "DF", or "F"; and E2 can have a value of "S", "M", or "L". If this combination of scenarios occurs, then show the value of A2. Same formula as the formula that works, same logical test.

Could there be a formatting issue on the data that's being pulled from the targeted cells? That said, all of the data was copy and pasted from another sheet, so these values were not entered organically.

Thanks, Dean

Skills: Data Entry, Data Processing, Excel, Mathematics, Statistics

See more: data entry or excel sheet and this types of mobile jobs , complete the marketing report below with articles a an and the if needed or else no article if not needed, and or excel, excel if statement multiple conditions range, or function excel, if and excel examples, nested if excel, if and excel multiple conditions, if and or excel together, if not excel, excel is not equal to, excel, images to be validated and checked if male or female, do some excel formula or macro, excel formula working hour, excel formula network address range, excel formula projects, excel macro search cells, excel macro comparing cells, excel formula convert utm latitude

About the Employer:
( 0 reviews ) United States

Project ID: #15942191

Awarded to:

MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document

$25 USD in 1 day
(59 Reviews)
5.8

9 freelancers are bidding on average $39 for this job

dvcontact

Hi, Reading your project description about fixing an Excel formula makes me feel like you have me in mind when creating the project. I have all it takes to deliver. You will find in my profile that I have track rec More

$30 USD in 1 day
(14 Reviews)
4.4
$25 USD in 1 day
(27 Reviews)
4.2
$10 USD in 1 day
(1 Review)
1.2
vignesh1093

Hi , iam working in excel for more than 2 years and iam in management information system team si mostly i will be using excel for creating dashboards and reports with formulas . so you can trust me and give the job. Th More

$20 USD in 1 day
(0 Reviews)
0.0
$100 USD in 1 day
(1 Review)
0.0
MDM5

I am a certified Microsoft Office Specialist, Got the ICDL Certification and the commercial excel course.I have a wide experience with formulas in excel such as IF, AND, OR, V LOOK UP....etc. so I think that I would b More

$20 USD in 1 day
(0 Reviews)
0.0
rishikevin07

RESUME Experience :- Total 6 Years in IT field. Last 4 years in PHP, MySQL, Laravel Sr. PHP/wordpress/joomla Developer / Team Leader / Project Leader (LAMP / WAMP) Skill Set Scripting Language PHP, Laravel Wordp More

$111 USD in 1 day
(0 Reviews)
0.0
$10 USD in 1 day
(1 Review)
0.4