Is it possible to combine the following three formulas into one formula so the results can be shown in one column instead of three?
=IF(AND(AD2>AI2,K2>AD2),”Above”,””)
=IF(AND(AD2>AI2,K2<=AD2,K2>=AI2),”Within”,””)
=IF(AND(AD2<AI2,K2<AI2),”Below”,””)
Column M contains either “Buy”, “Sell”, or “Hold” which I have already calculated.
I would then like to have another formula that would, in one column, match “Buy” and “Above” and give a result of “Strong Buy”; “Buy” and “Within” and give a result of “Medium Buy” and “Buy” and “Below” and give a result of “Weak Buy”.
If there is a better way than I have outlined above to achieve the desired results I would be happy to use it.
Thanks
Blair
=IF(AND(AD2>AI2,K2>AD2),”Above”,””)
=IF(AND(AD2>AI2,K2<=AD2,K2>=AI2),”Within”,””)
=IF(AND(AD2<AI2,K2<AI2),”Below”,””)
Column M contains either “Buy”, “Sell”, or “Hold” which I have already calculated.
I would then like to have another formula that would, in one column, match “Buy” and “Above” and give a result of “Strong Buy”; “Buy” and “Within” and give a result of “Medium Buy” and “Buy” and “Below” and give a result of “Weak Buy”.
If there is a better way than I have outlined above to achieve the desired results I would be happy to use it.
Thanks
Blair