Re: $$Excel-Macros$$ if formula help

Thanks CG,Andril & ashish On Wed, Dec 8, 2010 at 2:13 PM, ashish koul wrote: > try this you can avoid using multiple ifs with this > > > > > On Wed, Dec 8, 2010 at 11:48 AM, C.G.Kumar wrote: > >> Solved & file Attached. Hope it serves the purpose. >> >> Regards, >> >> C.G.Kumar >> >> >> >> On W

Re: $$Excel-Macros$$ if formula help

Solved & file Attached. Hope it serves the purpose. Regards, C.G.Kumar On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote: > Dear All, > > please help me with the formula where in I should get the result > > 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then > B2-30

Re: $$Excel-Macros$$ if formula help

Hi Abhinda, PFA the solution.. Regards, Andy On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote: > Dear All, > > please help me with the formula where in I should get the result > > 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then > B2-300, subsequelntly I hve tried

$$Excel-Macros$$ if formula help

Dear All, please help me with the formula where in I should get the result 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then B2-300, subsequelntly I hve tried but somehow i am not getting the desired result Regards Abhidha -- --