Use IF formula based on choice in another cell

[bdouglas1011]

I have a drop down choice in (D7) the Choices are "A/B - L/R" OR "N/S - E/W"
In (C15) I have the formula

=IF(B15>0,"Above","Below")

I need to change it to look @ cell (D7) and if they have chosen "A/B - L/R" then the existing formula is correct but if they have selected "N/S - E/W" then I need to use

=IF(B15>0,"North","South")

Thanks for your help

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

[bdouglas1011]

I have attached sample sheet

[Glenn Kennedy]

Thanks!

=IF($D$7="A/B - L/R",IF($B$15>0,"Above","Below"),IF($B$15>0,"North","South") )