Hi all
just a simple one how do u turn this result #N/A error into 0?
because it is effecting my calculations...
please see example sheet. thx
Hi all
just a simple one how do u turn this result #N/A error into 0?
because it is effecting my calculations...
please see example sheet. thx
Last edited by QuantEdge; 09-23-2017 at 11:14 AM.
Try
=IFERROR(MODE(A2:INDEX(A2:A100,10)),0)
In B2 copied down:
=IFNA(MODE(A2:INDEX(A2:A100,10)),0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Big thanks to both of you... ** nice lines.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks