1

I'm getting an error back for this formula. I've tried with commas, without space, short formula and I still can't seem to get it to work.

Here's the formula that I'm using:

=IF(OR(C3 = "Jenna"; C3 = "Maureen"; C3 = "Kelvin"; C3 = "Kevin"; C3 = "Rafael"; C3 = "Sean"; C3 = "Wing"; C3 = "Ariel"); "ACCTG"; =IF(OR(C3 = "Randy"; C3 = "Becca"); "AP"; =IF(OR(C3 = "Jack"; C3 = "Candace"); "PAYROLL"; =IF(OR(C3 = "Mike"; C3 = "Amy"; C3 = "Brett"; C3 = "Noah"; C3 = "Erick"; C3 = "Derrick"); "PM"; =IF(OR(C3 = "Daniel"; C3 = "Deep"; C3 = "Nicole"); "SRTGY"; "ERRR!")))))

I'm trying to get a text output based on a text value.

1

All works, just replaced =IF with IF, (apart from the 1st one).

=IF(OR(C3 = "Jenna"; C3 = "Maureen"; C3 = "Kelvin"; C3 = "Kevin"; C3 = "Rafael"; C3 = "Sean"; C3 = "Wing"; C3 = "Ariel"); "ACCTG"; IF(OR(C3 = "Randy"; C3 = "Becca"); "AP"; IF(OR(C3 = "Jack"; C3 = "Candace"); "PAYROLL"; IF(OR(C3 = "Mike"; C3 = "Amy"; C3 = "Brett"; C3 = "Noah"; C3 = "Erick"; C3 = "Derrick"); "PM"; IF(OR(C3 = "Daniel"; C3 = "Deep"; C3 = "Nicole"); "SRTGY"; "ERRR!")))))

I find it best to start with something short then join the statements, after I have things working.

I wish they would auto indent long formulas, to make them easy to fix/edit.

  • 1
    looks like =VLOOKUP() would be a better solution. – eddyparkinson Jan 3 '14 at 4:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.