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

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 6 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

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

Ταυτότητα εργασίας: 15942191

Σχετικά με την εργασία

8 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@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 σε 1 ημέρα

5,0

(67 αξιολογήσεις)

6,0

8 freelancers δίνουν μια μέση προσφορά $30 USD για αυτή τη δουλειά

@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 record of completing similar jobs on time and within budget. Let my reviews do the talking. Thanks Smith

$30 USD σε 1 ημέρα

4,8

(36 αξιολογήσεις)

5,8

@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. Thanks

$20 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

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 be an excellent match for your job with the minimum price offered and 5 years data entry experience.

$20 USD σε 1 ημέρα