fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 439
- Office Version
- 365
- Platform
- Windows
in the table below, i want to return TRUE if any of the cell within the row has an ERROR result and FALSE if there is none (see E2 below, then drag it all the way down).
e.g. E2 result is TRUE since B2 has an error, and E3 is FALSE because there is no error.
Thanks
e.g. E2 result is TRUE since B2 has an error, and E3 is FALSE because there is no error.
Thanks
A | B | C | D | E | |
1 | Item | Total | Person In-Charge | Dept | Any Error in a Row? |
2 | Car | #N/A | John | HR | TRUE |
3 | Dress | 52 | Mary | Finance | FALSE |
4 | Stationary | 25 | #REF! | HR | TRUE |
5 | Grocery | 12 | Mathew | #VALUE! | TRUE |