Nested IF Function
 

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

Nested IF Function
 

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

Cell formatted as %

"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

Nested IF Function
 

=IF(O2="FE",6%,IF(O2="EE",4%,IF(O2="ME",2%,0%)))
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Toppers" wrote:

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

Cell formatted as %

"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

Nested IF Function
 

Try this:

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

Format as %

Biff

<Ann wrote in message ...
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

Nested IF Function
 

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

Nested IF Function
 

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

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

XL2002, WinXP


"Ron Coderre" wrote:

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