Error check

[Steved]

Hello from Steved

2.34 2.45 2.41 3.54

Ok I have a row with similar to the above fiqures

I would like a formula that would check the row for an
error as for example 2.34 every fiqure is greater but you
will notice a typo 2.41 is less than 2.45, hence instead
of looking up hundreds off rows I would have the formula
return "Error" in row 13 each row is 12 cells wide.

Thankyou.

 

[Vasant Nanavati]

I hope I understand what you are trying to communicate.

If you want the error to show up in the 13th *column*, and assuming the 12
cilumns are A-L, use the following formula in column M:

=IF(SUM(--(B1:L1<A1:K1))>0,"Error","")

entered as an array formula with <Ctrl> <Shift> <Enter>.

It may be simpler to use conditional formatting.

 

[Biff]

Hi Steved!

Maybe something like this:

=IF(AND(B1>A1,C1>B1,D1>C1)=FALSE,"ERROR","")

Or, you could use conditional formatting to highlight any
row that might contain an error, instead.

What about the possibility of any cells being blank? How
do want to handle that?

Biff

 

[Steved]

Thankyou Gentlemen

-----Original Message-----
I hope I understand what you are trying to communicate.

If you want the error to show up in the 13th *column*, and assuming the 12
cilumns are A-L, use the following formula in column M:

=IF(SUM(--(B1:L1<A1:K1))>0,"Error","")

entered as an array formula with <Ctrl> <Shift> <Enter>.

It may be simpler to use conditional formatting.
--

Vasant








.