• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to find the error in formula

Hi Rush,

You have entered "=F2=Q2"
where F2=35900 and Q2=35901

Both values are not same so u getting "False"

if F2=35900 and Q2=35900

then your formula returns "True"

hope you got it.
 
Hi,
Q2 should always be equal to F2. I had written a formula from J to P and Q is the sum of J to P. I thought that after calculating It will come as F2 but Re 1 is coming extra.


Thanks
Raj
 
Hi Raj ,

This is a commonly encountered situation ; you want that Q2 should always be equal to F2.

F2 is the result of adding two values in D2 and E2 ; the value in D2 is a data entry value , which might or might not have decimal places. The value in E2 is through a formula which has just 2 values 0 or 20000. However , the formula in F2 ensures that the output in F2 will always be an integer.

Q2 is the sum of values in J2 through P2 , where each value is a calculated value being rounded off to result in an integer value.

It is clear that when so many values are being calculated through formulae , there is no guarantee that the summation of all the values will result in a desired value.

What is to be done to ensure that this happens is that one of these 7 values will need to be calculated as equal to F2 - SUM(the other 6 values) ; this is the only way you can be sure that the values in column Q will always equal the values in column F.

You decide which of these values will be that value ; all of the values such as Basic , DA , HRA , Conveyance and Outstation Allowance appear to be round figures ; thus the only candidates are Tiffin Allowance and Medical Allowance ; if either of these is calculated using the above technique , you can ensure that the values in columns Q and F will always match.

Narayan
 
Hi Narayan,

Thanks a lot for helping. But I am unable to do so request you to help in the excel provided as it would be of great help.


Thanks in advance.
Raj
 
You must log in or register to reply here.
Back
Top