IF cell problem

[gleeson82]

Hi,

New to the forum and just have what should be a fairly easy enough question.

I'm currently doing a spreadsheet for reproducibility. I've a requirement for an accuracy on the reproducibility to be 0.0 +/- 1. In theory I inject 20mLs 6 times but in reality I actually get my mean to be 20.1mLs (have some very simple excel formulaes to calculate weights versus volumes). What I'm trying to do is for my actual results to be subtracted from my theoritical results and if the result is between my specification i.e +/-1 the cell will say pass, otherwise if says fail. I'm trying the formulae below where P42 = 1, N52 = 20 and O58 = 20.1 but the cell just says fail. Could someone please direct me where I would be going wrong.

=IF(-P42<=(N52-O58)<=P42,"Pass","Fail")

thanks for the help in advance

[Richard Buttrey]

Hi,

How about

=IF(ABS(N52-O58)<P42,"Pass","Fail")

HTH

[gleeson82]

works a treat, thanks very much for this

[gleeson82]

sorted, thanks