# Excel If statement help

I've been trying to come-up with excel formula that provide me with a answer if the condition that i set are being met?

Example

``````Item     Records     Actual count  Diff. %    % Tolerance    Tolerance ok?
PCMA      525          541           3.0%         10.0%          Yes
PCLY      262          250           -4.6%         4.0%          No
``````

But using

``````=if(and(Diff.%,%tolerance),"yes","no")
``````

give me an answer of both yes..if possible to ask if there is a way that i can come up with the correction formulation.

• in the case of DIFF.% is greater than Tolerance and DIFF.% is equal on the % Tolerance can you please provide me an excel formula that will provide all the answer that i seek...Thank you very much – joram Mar 15 '17 at 3:31
• We can’t help you if you don’t tell us what you want.  What condition(s) do you want to test?  What results do you want to get?  What do you mean by `and(Diff.%,%tolerance)`? – Scott Mar 15 '17 at 3:34
• The AND just checks whether everything in its list is "true". Any non-zero numeric value is interpreted as true. You need to test for the condition you're looking for, such as Sir Adelaide suggests. – fixer1234 Mar 15 '17 at 20:18

``````=if(abs(diff)<Tolerance,"Yes","No")