Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
=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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |