Embaded If Formulas

[hamburg18w]

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

 

[AnotherHiggins]

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.

 

[skitrumpet]

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