LinkBack URL
About LinkBacks
Is it possible to have in one formula to include IFERROR then leave blank and IF 0 then leave blank?
I can do one or the other but not both..
Any help is appreciated.
Thank you,
Is it possible to have in one formula to include IFERROR then leave blank and IF 0 then leave blank?
I can do one or the other but not both..
Any help is appreciated.
Thank you,
=IFERROR(IF(your_formula)=0,"",your_formula),"")
That should do it for you
Last edited by Speshul; 06-08-2016 at 03:36 PM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Thank you for the reply.
I'm having problems adding it to the formula below..
=INDEX('Data'!$R$2:$R$80,MATCH(1,INDEX(('Data'!$A$2:$A$80=Meow!$D$2)*('Data'!$B$2:$B$80=Meow!B4),0,1),0))
Try
=IFERROR(IF(INDEX('Data'!$R$2:$R$80,MATCH(1,INDEX(('Data'!$A$2:$A$80=Meow!$D$2)*('Data'!$B$2:$B$80=Meow!B4),0,1),0)))=0,"",INDEX('Data'!$R$2:$R$80,MATCH(1,INDEX(('Data'!$A$2:$A$80=Meow!$D$2)*('Data'!$B$2:$B$80=Meow!B4),0,1),0))),"")
No such luck
What are you trying to do with the formula? I'm a little confused at it's structure
Try this
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
Don't forget that if you are using Index you much set is as an array not just Enter but Alt+Enter
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks