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

2010-01-27 Thread Dilip Pandey
Dear TAIgo, Attached file had the circular reference error, now resolved. Please get back in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jan 27, 2010 at 12:35 AM,

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

2010-01-26 Thread ankur
hi taigo for uploading file just reply this mail with attaching file On 27/01/2010, TAlgo wrote: > I cant upload the file so emailing you..if you know how to upload > please go ahead... > > Thanks again > > Dilip Pandey wrote: >> Hi TAIgo, >> >> According to me you should be getting circular ref

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

2010-01-26 Thread TAlgo
I cant upload the file so emailing you..if you know how to upload please go ahead... Thanks again Dilip Pandey wrote: > Hi TAIgo, > > According to me you should be getting circular reference error because you > are Adding B1+A2 being in Cell A2. Try uploading a sample file so that we > can help

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

2010-01-26 Thread TAlgo
Yes, I am getting cicrular reference error. Any idea how to resolve it? I have uploaded file 'if...then.xls in Upload section.. thanks in advance.. Dilip Pandey wrote: > Hi TAIgo, > > According to me you should be getting circular reference error because you > are Adding B1+A2 being in Cell A2

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

2010-01-26 Thread Dilip Pandey
Hi TAIgo, According to me you should be getting circular reference error because you are Adding B1+A2 being in Cell A2. Try uploading a sample file so that we can help you better. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan.

$$Excel-Macros$$ if then formula - help needed

2010-01-26 Thread TAlgo
A2 =IF(A1="buy",(B1+A2),A2) if A1 is buy then add value in (B1+A2) or else keep value of A2.. A3 = IF(A1="sell",(B1+A3,A3) if A1 is sell then add value in (B1+A3) or else keep value of A3 cant get it work..above formula... thanks -- ---