Answer must be in Excel based formula for in column K . f3 = original measuremen

Question

Answer must be in Excel based formula for in column K .

f3 = original measurement , g3 = after measurement

=(((G3-F3)/F3)*100) - this formula correctly returns percent change of measurements

Now I need a formula that returns whether the percent change is acceptable. Say -3% and +1%

=IF(OR(H3<I3,H3>J3),"UNSAT","SAT") this formula is wrong I Need a new approach. when I check my answer and its -3% it should be accpeted (SAT) but its not.

cell h has the %change answer my example -3%

Cell I and J are the requirements -3% and +1%

this example needs to say SAT because its at 3.00% what is wrong?

Answer must be in Excel based formula for in column K . f3 = original measurement , g3 = after measurement =(((G3-F3)/F3)*100) - this formula correctly returns percent change of measurements Now I need a formula that returns whether the percent change is acceptable. Say -3% and +1% =IF(OR(H3J3),''UNSAT'',''SAT'') this formula is wrong I Need a new approach. when I check my answer and its -3% it should be accpeted (SAT) but its not. cell h has the %change answer my example -3% Cell I and J are the requirements -3% and +1% this example needs to say SAT because its at 3.00% what is wrong?

Explanation / Answer

Change the formula to:

=IF(AND(H3>=I3,H3<=J3),"SAT","USAT")

But there seems to be no issue to me with the formula you are using.

However, when you are checking for an equality in excel, excel chexk for the true value in a cell e.g. the true value calculated in a cell might be -2.99999999 but excel shows it to you as -3 but while checking the if condition it checks if the test value is equal to -2.999999 and not the value which is visible.

This should work!! :)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---