Hi Experts,
Can you please help me with my problem regarding Pass and Fail condition
The Criteria or Acceptance region is 98-102 is Passed, Below 98 = Failed
103 Up Failed. Can you please help me figure out the formula.
The formula Im using is
=IF(A1<98,"Failed",IF(A1>98,"Passed",IF(A1>=103,"Failed")))
But I dont have any luck.
Thank you.
thong
Bookmarks