| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested Ages Plus or Minus (IF)
I used the following formula to ask MS Excel to compare two age fields to see
if they are within one year (plus or minus) of matching each other. (It returned all "NO" answers, which was incorrect). =IF(((B2=C2)*OR(B2=C2+1)*OR(B2=C2-1)*OR(B2+1=C2)*OR(B2-1=C2)),"YES","NO") 'Suggestions, please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating ages | Excel Discussion (Misc queries) | |||
| calculating ages | Excel Worksheet Functions | |||
| CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
| dates into ages | Excel Worksheet Functions | |||
| how can i show two layers of plus/minus signs for nested groups | Excel Discussion (Misc queries) | |||
Threaded Mode
