IF Statement Inquiry

**Down Under** · 03-26-2012, 08:43 AM

Try this:

=if(max(abs(b2:e2))<=0.02,1,"error")

As this formula involves an array you have to hit ctrl + shift + enter for it to work.

**Opus1** · 03-26-2012, 11:11 AM

Hi NBVC,

Thanks for your replies. When ever there is a variance in any of the cells B2, C2, D2 or E2, I would like "Error" to show up when the variance is greater then +/- 2 cents. So if the cell has a value of 3 cents or higher or - 3 cents, -4 cents...etc, "Error" is the result. If any one of the cells has a value of -0.02, -0.01, 0, 1 or 2, I need "1" to shows up.

Also thank you Down Under for your reply. I have tried your formula but got a "#VALUE!" error.

**NBVC** · 03-26-2012, 01:10 PM

Originally Posted by Opus1

Hi NBVC,

Thanks for your replies. When ever there is a variance in any of the cells B2, C2, D2 or E2, I would like "Error" to show up when the variance is greater then +/- 2 cents. So if the cell has a value of 3 cents or higher or - 3 cents, -4 cents...etc, "Error" is the result. If any one of the cells has a value of -0.02, -0.01, 0, 1 or 2, I need "1" to shows up.

.

Probably need the OR with operations reversed...

e.g

=IF(OR(ABS(B2)>0.02,ABS(C2)>0.02,ABS(D2)>0.02,ABS(E2)>0.02),"ERROR",1)