comparing one to one cell within range
 

I am trying to compare each cell to the one below and this for a whole range.
The difficulty comes form the fact that I need to have an alert in one
formula.
Something like
if (A1:A10<B1:B10, "Warning", "")
the warning will appear only if A1<B1 or A2<B2 or A3<B3 and so on.
Any idea?
THanks
--
caroline

comparing one to one cell within range
 

Try this:
=IF(SUMPRODUCT(--(A1:A10<B1:B10)),"Warning","")

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"caroline" wrote in message
...
I am trying to compare each cell to the one below and this for a whole
range.
The difficulty comes form the fact that I need to have an alert in one
formula.
Something like
if (A1:A10<B1:B10, "Warning", "")
the warning will appear only if A1<B1 or A2<B2 or A3<B3 and so on.
Any idea?
THanks
--
caroline

comparing one to one cell within range
 

wonderful thanks
--
caroline


"Ron Coderre" wrote:

Try this:
=IF(SUMPRODUCT(--(A1:A10<B1:B10)),"Warning","")

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"caroline" wrote in message
...
I am trying to compare each cell to the one below and this for a whole
range.
The difficulty comes form the fact that I need to have an alert in one
formula.
Something like
if (A1:A10<B1:B10, "Warning", "")
the warning will appear only if A1<B1 or A2<B2 or A3<B3 and so on.
Any idea?
THanks
--
caroline

comparing one to one cell within range
 

You're welcome......I'm glad I could help.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"caroline" wrote in message
...
wonderful thanks
--
caroline


"Ron Coderre" wrote:

Try this:
=IF(SUMPRODUCT(--(A1:A10<B1:B10)),"Warning","")

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"caroline" wrote in message
...
I am trying to compare each cell to the one below and this for a whole
range.
The difficulty comes form the fact that I need to have an alert in one
formula.
Something like
if (A1:A10<B1:B10, "Warning", "")
the warning will appear only if A1<B1 or A2<B2 or A3<B3 and so on.
Any idea?
THanks
--
caroline