| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing cell contents, know cell address | Excel Discussion (Misc queries) | |||
| Comparing One Range and Adding Another | Excel Worksheet Functions | |||
| Comparing a Range of Values | Excel Discussion (Misc queries) | |||
| comparing cell | New Users to Excel | |||
| Comparing a cell result with a pre-defined value range | Excel Worksheet Functions | |||
Linear Mode
