Here's one option:

=SUM(COUNTIF(O2,{"FE","EE","ME"})*{3,2,1})*2%

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ann" wrote:

I know that this should be simple, but I can't get it to work.

I want a function that says:

If O2=FE, 6%
If O2=EE, 4%
If O2=ME, 2%
If O2 = anything else, 0

Can anyone help with this? Thanks!

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com