worksheet for calculating astakvarga points from file area

[Guest guest]

Dear Mr. Dasgupta ,

 

I have a query about your worksheet named worksheet transit aqs krushna .

 

Here for calculating the astakvarga points the following formula is used .

 

=IF(E11=B6,C6,IF(E11=B7,C7,IF(E11=B8,C8,IF(E11=B9,C9,IF(E11=B10,C11,IF(E11=B11,C11,0))))))

 

I have highlighted a part of the formula. I feel this part is incorrect . It should read E11=B10 , C10, and not c11 as given above .

 

Thanks in advance .

 

Regards ,

 

Anand--------------------

[Guest guest]

Dear Anand,

 

Thanks. I shall check it. I am glad that somebody has taken a note of the worksheet at last.

 

regards

 

Dasgupta

 

-

Anand

Sunday, September 16, 2001 6:29 AM

worksheet for calculating astakvarga points from file area

 

Dear Mr. Dasgupta ,

 

I have a query about your worksheet named worksheet transit aqs krushna .

 

Here for calculating the astakvarga points the following formula is used .

 

=IF(E11=B6,C6,IF(E11=B7,C7,IF(E11=B8,C8,IF(E11=B9,C9,IF(E11=B10,C11,IF(E11=B11,C11,0))))))

 

I have highlighted a part of the formula. I feel this part is incorrect . It should read E11=B10 , C10, and not c11 as given above .

 

Thanks in advance .

 

Regards ,

 

Anand