Originally Posted by
JazzMan
Hi,
I'm getting a #NUM! error when using the SMALL function. I have entered =SMALL(V2:z2,1) which is correct. The problem appears to occur because cells V2:Z2 contain formulas, not pure numbers.
If I test the function on different cells that contain only numbers, it works fine, but it won't work on the cells I need it for. The cells contain formulas which produce an integer (1,2,3,4,5 or 9) so I don't see why it should cause a problem, but it just won't work.
I have tried the official help and it doesn't mention any restrictions in its use. Can anyone else help me out?
Bookmarks