Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Embaded If Formulas

Status
Not open for further replies.

hamburg18w

Technical User
Dec 27, 2005
32
US
I am running excel 2003 and need some help with embaded if formulas. Let me try to describe what I need.

Column E is a tropdown list of codes
Column H has the if formula

Example:
if column E is 8550 or 5486, = 3, if column E is 8510 or 8520 or 8540, etc. = 1

Please help.

Juan
 
The "etc." leads me to suspect that there are several options in the dropdown.

What you want isn't a series of nested IFs (which is limited to only 7 nested statements in XL 2003 anyway), but rather a VLookup.

Search Excel's help file for "VLookup". Let us know if you need assistance constructing the formula.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
If only 8550 or 5486 need to be tagged with 3 and this will not change you could use:

=if(or(E1=8550,E1=5486),3,1)


Hope this helps

Adam
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top