If statement to have two different cells changed

[visitor13]

Hi excel experts,

I am learning excel. I have the following formula that doesn't work as planned yet (only 50 %).

=IF(P8="", "SHORT...", IF(P8>0, "SHORT CALL", IF(R8>0, "SHORT PUT")))

The cell N8 shows SHORT... this is okay. When I enter a number in cell P8 (must be greater than 0) the cell N8 changes to SHORT CALL. This works fine, too.
When I enter a number in cell R8 (again, must be greater than 0) the cell N8 should/must change to SHORT PUT, but it doesn't.

Another question... would it be also possible to have cell N8 changed to SHORT STRANGLE if both cells (P8 and R8) have a number (bigger than 0) entered? If yes, how can this be done?

Thank you, visitor13

 

[James006]

Hi,

The best "Option" is to have a reference table and forget all nested ifs ...and use a simple VLookup()

 

[visitor13]

Hi,

The best "Option" is to have a reference table and forget all nested ifs ...and use a simple VLookup()

Hi James006,

Thank you for your message and suggestion. I applied some changes and the new formula looks like this...

=IF(P8>0, "SHORT CALL", IF(R8>0, "SHORT PUT", "SHORT..."))

SHORT... SHORT CALL and SHORT PUT work perfectly with this new formula. Now I am trying to get the following done... to have cell N8 changed to SHORT STRANGLE when entering a number in both cells (P8 and R8). Working on it...*

*I want to try this with nested ifs, too. If anyone has an idea how to do it, please let me know.

Thank you, visitor13

 

[Peter_SSs]

to have cell N8 changed to SHORT STRANGLE when entering a number in both cells (P8 and R8).

Is this what you want?

=IF(P8*R8>0,"SHORT STRANGLE",IF(P8>0, "SHORT CALL", IF(R8>0, "SHORT PUT", "SHORT...")))

*I want to try this with nested ifs, too. If anyone has an idea how to do it, please let me know.

My formula and yours are already 'nested IF' formulas.

 

[visitor13]

Hi Peter_SSs,

Thank you for your message and suggestion. Your solution works like a charm and is exactly what I was looking for.

Thanks again, visitor13

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.