# Problem in Calculation

1. ## Problem in Calculation

Hi,

Please help me to solve the formula on 3 columns (column J, K, L). i tried to solve but i can't.

Column J = If Monthly Gross is < 40000 then the formula is applicable
Column K = If Monthly Gross is < 40000 then the formula is applicable
Column L = If Monthly Gross is >= 40000 then the formula is applicable  Register To Reply

2. ## Re: Problem in Calculation

Hello Sanjibghosh,

monthly gross is available in column N, isn't it?  Register To Reply

3. ## Re: Problem in Calculation

Hi kuschem,

Yes, monthly gross is available in column N.  Register To Reply

4. ## Re: Problem in Calculation

SUCH THAT IN MONTHLY GROSS COLUMN N formula is =SUM(F4:M4)  Register To Reply

5. ## Re: Problem in Calculation

you can enable circular references by
select File---> options----> formula-----> check ENABLE ITERATIVE calculation

Hope this helps
Regards
Hemesh

If this helps click Star button to Add Reputation  Register To Reply

6. ## Re: Problem in Calculation

in the File posted in #5 you get from a basic of 14000 to gross of over 51000 which is in a large part due to "iterative nature" of the gross calculation (SUM(Ff\$:M4). the latter includes the allowance in L4.

Without L4 the Gross would be 29,200 and surely the L4 calculation should be based on this (as should those in J and K) ????  Register To Reply