Nested IF Function

[Ann]

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

 

[Toppers]

=IF(O2="FE",6%,IF(O2="EE",2%,IF(O2="ME",2%,0%)))

Cell formatted as %

 

[Dave F]

=IF(O2="FE",6%,IF(O2="EE",4%,IF(O2="ME",2%,0%)))

 

[T. Valko]

Try this:

=IF(O2="FE",0.06,IF(O2="EE",0.04,IF(O2="ME",0.02,0)))

Format as %

Biff

 

[Ron Coderre]

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

 

[Ron Coderre]

Shorter version of my posted formula:
=SUM((O2={"FE","EE","ME"})*{3,2,1}*2%)

Does that help?
***********
Regards,
Ron

XL2002, WinXP