how to find small and max value for the attached sheet without error #num
how to find small and max value for the attached sheet without error #num
Change:
=IF(H2="","0",(LEFT(H2,FIND("/",H2)-1)))
to:
=IF(H2="","0",VALUE(LEFT(H2,FIND("/",H2)-1)))
Last edited by Phuocam; 06-13-2018 at 07:36 AM.
thanks for your quick reply Phuocam worked...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks