| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax to "OR" 3 "ISERROR" conditions
Oh Wise Ones,
I would like to filter the conditions of 3 columns for errors and evaluate in a fourth. I need a null value not just a white font. I've played with the OR syntax and nothing works. Any ideas please? Basically I need in D1: IF A1 OR B1 OR C1 is in error "" else C1. Thanks, Mike |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax to "OR" 3 "ISERROR" conditions
Try this array =IF(ISERROR(A1:C1),"",C1) Enter in D1 with Ctrl + Shift + Enter or this alonger non arrays =IF(OR(ISERROR(A1),ISERROR(B1),ISERROR(C1)),"",C1) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563980 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax to "OR" 3 "ISERROR" conditions
=IF(OR(ISERROR(A1),ISERROR(B1),ISERROR(C1)),"",C1)
Regards, Alan. "Mike K" wrote in message ... Oh Wise Ones, I would like to filter the conditions of 3 columns for errors and evaluate in a fourth. I need a null value not just a white font. I've played with the OR syntax and nothing works. Any ideas please? Basically I need in D1: IF A1 OR B1 OR C1 is in error "" else C1. Thanks, Mike |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax to "OR" 3 "ISERROR" conditions
Alan, I suugested that too. Give him the option VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563980 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax to "OR" 3 "ISERROR" conditions
Your reply wasn't on the screen when I replied, if it had been I wouldn't
have duplicated it. Your array formula is a good one, Regards, Alan. "VBA Noob" wrote in message ... Alan, I suugested that too. Give him the option VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563980 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax to "OR" 3 "ISERROR" conditions
Doh...My bag. I saw your or and thought it was another suggestion. VbA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563980 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Syntax to "OR" 3 "ISERROR" conditions
Thanks.
"VBA Noob" wrote: Try this array =IF(ISERROR(A1:C1),"",C1) Enter in D1 with Ctrl + Shift + Enter or this alonger non arrays =IF(OR(ISERROR(A1),ISERROR(B1),ISERROR(C1)),"",C1) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563980 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct-multiple criteria for same range "OR" | Excel Worksheet Functions | |||
| Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
| using multiple conditions | Excel Discussion (Misc queries) | |||
| Syntax for 2 AND conditions within an OR function. | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Linear Mode
