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,
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
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
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
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.
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
--
---