I am using the following formula and cannot figure out how or where to insert the ISERROR function to return a blank cell. Help please?
=IF(K51>=$N$28,1,(IF(K51>=$N$29,2,(IF(K51>=$N$30,3,(IF(K51>=$N$31,4,(IF(K51<=$N$32,5,"")))))))))
I am using the following formula and cannot figure out how or where to insert the ISERROR function to return a blank cell. Help please?
=IF(K51>=$N$28,1,(IF(K51>=$N$29,2,(IF(K51>=$N$30,3,(IF(K51>=$N$31,4,(IF(K51<=$N$32,5,"")))))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks