| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return true if multiple cells are the same
I have cells A1 to E1 with same values. In cell F1, I want to return "true"
if cell A1=B1=C1=D1=E1. The result I get was #N/A when I enter the formula "=A1=B1=C1=D1=E1". Anyone knows the answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| return multiple corresponding values in excel | Excel Worksheet Functions | |||
| Return number of cells filled | New Users to Excel | |||
Threaded Mode
