I have a range of data for which I need to display the lowest value out of the data in a separate cell. I have been trying to use nested If statements but keep getting the #value error. Please help.
I have a range of data for which I need to display the lowest value out of the data in a separate cell. I have been trying to use nested If statements but keep getting the #value error. Please help.
Last edited by JBeaucaire; 08-11-2012 at 10:30 PM. Reason: Changed title to describe the need, not guess at the answer. Be sure to read the Forum rules when you get a moment. ;)
have you tried to use =min()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Bear77,
Are you looking to find MIN against some criteria ?
Is there some errors cells in your data .. like #n/a etc. ?
Please upload a sample workbook... thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks