IF(AND with 3 Results

[Mike Slattery]

I would like to produce an IF(AND formula that outputs three results? The three results would be "BUY", "HOLD", and "SELL".

The obvious restraint if an IF(and statement only allows for a "TRUE" and / default "FALSE" result.

Has anyone developed a work around for this situation?

Thanks Michael

Here is the current formula

=IF(AND(GT3=GT4,GD3>GD4,GB3>55),"BUY","SELL")

 

[Snakehips]

Mike,

Surely, you will be needing to nest IF's if you require 3 possible results???

What condition should produce "HOLD" ???

 

[Mike Slattery]

Hi Snakehips ;√)

Thanks for the assistance. When GT3 = GT4 I want the result to be "HOLD".

Michael

 

[Snakehips]

Is your original formula a valid formula that tests for BUY & SELL???

If so then.....

=IF(AND(GT3=GT4,GD3 > GD4,GB3 > 55),"BUY",IF(GT3 = GT4,"HOLD","SELL"))

If not then please post the correct conditions for Buy and Sell

 

[Mike Slattery]

Thanks, I just discovered that my problems are deeper than this one formula.

TBC hopefully,

Michael