May 15 2023 11:54 PM
The deviation is within the limit . But the status is showing fail.
May 16 2023 12:10 AM
@ajmal pottekattil yoousuf
Select L11 (Deviation) > Press F2 > Press F9 => -0.000500000000002387
ABS(-0.000500000000002387) > 0.0005 (result of VLOOKUP) => TRUE