How can I get the minimun if I have a #DIV/0!
EX.
A
6.5
12.8
#DIV/0!
7.9
#DIV/0!
4.8
= Minimun
Thanks for helping
How can I get the minimun if I have a #DIV/0!
EX.
A
6.5
12.8
#DIV/0!
7.9
#DIV/0!
4.8
= Minimun
Thanks for helping
This formula worked for me:
=MIN(IF(ISERROR(A1:A7),999999999,A1:A7))
Note: You need to commit that array formula by holding down [Ctrl][Shift] when you press enter.
(the 999999999 can be replaced with any large value that won't be the smallest in your list.)
I hope that gets you on the right track.
Regards,
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks