• 0

superN00B IF help in Excel '03


Question

I have created a list in my cell "B1" that is composed of various professions. I want to create an If Statement that will automatically fill in another cell based on what the user selects as the profession, but I'm having a hell of a time - for some reason, Excel is giving me an error message and highlighting the IF immediately before "((B1="Police Officer"). Here is my If Statement.

=IF((B1="Airline Pilot"),9500,IF((B1="Business Manager"),4600,IF((B1="Doctor (MD)"),13200,IF((B1="Engineer"),4900,IF((B1="Janitor"),1600,IF((B1="Lawyer"),7500, IF((B1="Mechanic"),2000,IF((B1="Nurse"),3100, IF((B1="Police Officer"),3000, IF((B1="Secretary"),2500, IF((B1="Teacher (K-12)"),3300, IF((B1="Truck Driver"),2500,"")))))

I have already checked my list to make sure that "Police Officer" is in it exactly the same - it was. Any help would be awesome.

Update/Note: It works perfect if I delete everything after the Nurse statement. Also, nothing after the Nurse statement works - if I delete Police Officer, the last ones don't work.

Son of a bitch, I am pretty sure it's an issue with how many embedded IF statements there are. Is there any way that I can use all these IF statements or at least have all this stuff in one cell without the use of a VLOOKUP or something of the like?

Update - well, turns out I just did it with a VLookup. It was actually much easier than I had anticipated. Stupid 7 nested IF's.

Edited by Dave Diller
Link to comment
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.