Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings. *

2012-10-19 Thread Hilary Lomotey
THANKS BOSS On Fri, Oct 19, 2012 at 5:20 PM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (palande.swapni...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

2012-10-19 Thread Swapnil Palande
Hi, Try below formula. =IF(AND(A1<=-0.5,A1>=-1),"STRONG BUY",IF(AND(A1<=-0.2,A1>=-0.49),"BUY",IF(AND(A1<=0.19,A1>=-0.19),"HOLD",IF(AND(A1<=0.49,A1>=0.2),"STRONG SELL",IF(AND(A1<=1,A1>=0.5),"SELL",FALSE) Regards, Swapnik. On Oct 19, 2012 10:08 PM, "Hilary Lomotey" wrote: > Hello Experts >

$$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

2012-10-19 Thread Hilary Lomotey
Hello Experts i need a formula such that if my results falls between the categories listed below, i get the ratings eg if my result in cell A1 is -25.3% then i shd get a rating of BUY, If cell A1 is say 2% then i shd get a HOLD rating. -50% -100% STRONG BUY -20% -49% BUY -19% 19% HOLD 50% 1