Double IF Function Help Needed

[BrianExcel]

I need a formula for one cell that will perform the following two steps:

1. IF H22=Y then display 1
OR
2. IF H22=N then display -1

Right now I have used IF((H22="Y")1,-1) but that displays -1 anytime Y is not displayed. As a default the cell value starts with "Select a value" displayed, and since "Select a value" is NOT "Y" as indicated in formula, it shows -1. I ONLY want -1 to show up if "N" is selected...

????

 

[jeffreybrown]

How about...

=IF(H22="Y",1,IF(H22="N",-1,""))

 

[BrianExcel]

AWESOME!!!

THanks jeff! Absolutely perfect!

 

[T. Valko]

I need a formula for one cell that will perform the following two steps:

1. IF H22=Y then display 1
OR
2. IF H22=N then display -1

Right now I have used IF((H22="Y")1,-1) but that displays -1 anytime Y is not displayed. As a default the cell value starts with "Select a value" displayed, and since "Select a value" is NOT "Y" as indicated in formula, it shows -1. I ONLY want -1 to show up if "N" is selected...

????

Try it like this...

=IF(H22="Y",1,IF(H22="N",-1,""))

 

[jeffreybrown]

You're welcome Brian...Glad it worked for you