I am trying to create a forumla that will subtract two columns and in the third column tell me if the one column is greater than the other column by 10%. So far I have IF(AND(A:A-B:B>(10%)*(A:A)=TRUE),C2,"FALSE") which is giving me false for everything but I know that some of the rows should be true.

Question

I am trying to create a forumla that will subtract two columns and in the third column tell me if the one column is greater than the other column by 10%. So far I have IF(AND(A:A-B:B>(10%)*(A:A)=TRUE),C2,"FALSE") which is giving me false for everything but I know that some of the rows should be true.

Answer 1

It is not clear which value you are using as the basis for your percentage.

You will also need to deal with when the percentage is negative.

try this (from my row 25!)

=IF(OR(ABS((A25-B25)*100/B25)>10,ABS((B25-A25)*100/A25)>10),1,0)

not neat but it does seem to work. It will return 1 when one of the the percentage differences is greater than 10% and 0 when less than 10%. You can replace the 1 and 0 with what ever you want.

Any use?