LinkBack URL
About LinkBacks
Is it possible to do an IFERROR and AND formula? There's 2 possible results for the IFERROR.
e.g
IFERROR AND A1="X"
IFERROR AND A1="Y"
Thanks
Is it possible to do an IFERROR and AND formula? There's 2 possible results for the IFERROR.
e.g
IFERROR AND A1="X"
IFERROR AND A1="Y"
Thanks
Probably something like this:
=IF(AND(ISERROR(B1),A1="X"),1,IF(AND(ISERROR(B1),A1="Y"),2))
I think you need to use OR instead of AND
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Paul, thanks. Sorry ,I probably shouldve mentioned, the formula goes in A1.
The true result has to be X1 (when X is true) or Y1 (when Y is true) in cell A1
AlKey, just saw your post. Im not sure that will work.
Please note: Im using lookups with ranges and theres no lookup value at the start of the range.
e.g. LOOKUP(2,1/($B$2:$B10<>""),$B$4:$B10)="X2",A5="X")
Sometimes between B2:B10 there is no value yet and it produces an error. Its an IF AND formula and requires A5=X or Y also
Last edited by prudential; 04-25-2018 at 08:46 AM.
What cell is X? What cell is Y? What should cell should be the error?
Ar you looking ofr something like:
=if(and(x="TRUE",iferror(B1)),"X1",if(and(Y="TRUE",iferror(B1)),"Y1","Error"))
IF(AND(LOOKUP(2,1/($B$2:$B4<>""),$B$2:$B4)="X2",$A5="X"),"X1",
IF(AND(LOOKUP(2,1/($B$2:$B4<>""),$B$2:$B4)="Y2",$A5="Y")),"Y1",
lets say the formula is in C5 (sorry)
Last edited by prudential; 04-25-2018 at 08:59 AM.
It is yours direct responsibility to provided accurate requirements. The example in your original post as totally misleading.Originally Posted by prudential
Sorry AL, I'll try and do better next time.
Im guessing ISBLANK is the better option?
Last edited by prudential; 04-25-2018 at 09:01 AM.
If(and(a5="x",sumproduct(--($b$2:b4<>""))=0),"x1",
if(and(a5="y",sumproduct(--($b$2:b4<>""))=0),"y1",
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks