Help with IFERROR function replacement
I would like please to replace the IFERROR function from the formula below with a function from my apple app supported functions listed in the table following link, in order to eliminate the #N/A when no data entered in cell B8:
http://support.dataviz.com/support_i...l#dtg_iphone21
=IFERROR(INDEX(A25:Y30,MATCH(D8,$A$25:$A$30,0),MATCH(B8,$A$25:$Y$25,0)),"")
=if(isna(MATCH(B8,$A$25:$Y$25,0)),"",INDEX(A25:Y30,MATCH(D8,$A$25:$A$30,0),MATCH(B8,$A$25:$Y$25,0)))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you it works fine,
How do I apply please the same if(isna for the following formula:
=C8+F8+G8
why would you get #N/A for that?
IF Cell G8 is blank (No Data)
shouldn't make any difference
you could try =sum(C8,F8,G8) instead but since this is not excel cant guarantee it
The formula returns now (0) insted of (#N/A) with not data entery in G8, which is fine by me, sorry but how would I apply please the same thing to a nigative formula like =N8-E8
Last edited by Khaldon; 08-22-2013 at 06:51 AM.
not much info there
what is in those cells
but you can wrap any formula in isna()
=if(isna(N8-E8),"",N8-E8)
isn't there a user guide?
That dose it, thank you,
Unfortunately no user guide.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks