| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show True if numbers match
In cells DZ4:EG4, I have some numbers. In EH4 I would like to enter a
formula which checks if all the numbers shown match each other, i.e. if they are consistent across the board. If the numbers match, I'd like to show True. If one or more of the figures is different, I'd like to show False. Any ideas on how to do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show True if numbers match
Try something like this:
If all of the values will be numbers... =(COUNTIF(DZ1:EG1,DZ1)=8) or if there may be non-numerics... =AND(ISNUMBER(DZ1),(COUNTIF(DZ1:EG1,DZ1)=8)) Does that help? *********** Regards, Ron XL2002, WinXP "Sarah (OGI)" wrote: In cells DZ4:EG4, I have some numbers. In EH4 I would like to enter a formula which checks if all the numbers shown match each other, i.e. if they are consistent across the board. If the numbers match, I'd like to show True. If one or more of the figures is different, I'd like to show False. Any ideas on how to do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show True if numbers match
Try this:-
=IF((SUM(DZ4:EG4)/8)=DZ4,"All the same","Odd numbers") Mike "Sarah (OGI)" wrote: In cells DZ4:EG4, I have some numbers. In EH4 I would like to enter a formula which checks if all the numbers shown match each other, i.e. if they are consistent across the board. If the numbers match, I'd like to show True. If one or more of the figures is different, I'd like to show False. Any ideas on how to do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show True if numbers match
try
=if(or(DZ4:EG4<DZ40,"False","True") entered as an array control-shift-enter "Sarah (OGI)" wrote: In cells DZ4:EG4, I have some numbers. In EH4 I would like to enter a formula which checks if all the numbers shown match each other, i.e. if they are consistent across the board. If the numbers match, I'd like to show True. If one or more of the figures is different, I'd like to show False. Any ideas on how to do this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show True if numbers match
That worked great, thank you!
"Ron Coderre" wrote: Try something like this: If all of the values will be numbers... =(COUNTIF(DZ1:EG1,DZ1)=8) or if there may be non-numerics... =AND(ISNUMBER(DZ1),(COUNTIF(DZ1:EG1,DZ1)=8)) Does that help? *********** Regards, Ron XL2002, WinXP "Sarah (OGI)" wrote: In cells DZ4:EG4, I have some numbers. In EH4 I would like to enter a formula which checks if all the numbers shown match each other, i.e. if they are consistent across the board. If the numbers match, I'd like to show True. If one or more of the figures is different, I'd like to show False. Any ideas on how to do this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show True if numbers match
=AND(DZ4:EG4=DZ4)
ctrl+shift+enter, not just enter "Sarah (OGI)" wrote: In cells DZ4:EG4, I have some numbers. In EH4 I would like to enter a formula which checks if all the numbers shown match each other, i.e. if they are consistent across the board. If the numbers match, I'd like to show True. If one or more of the figures is different, I'd like to show False. Any ideas on how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare data / MATCH(TRUE.. ROW.. | Excel Discussion (Misc queries) | |||
| Conditional Formating a cell .. to Show Nothing .. if True | Excel Worksheet Functions | |||
| How do I show True as a value in Excel B2 if Cell B1 is bold? | Excel Worksheet Functions | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| Match a1 to B1:B10, = true | Excel Discussion (Misc queries) | |||
Linear Mode
