hehe... stupid mistake on my part..I tried what you had said the firs
time and I was getting errors...I thought the syntax was off

turns out my formula was still passing a negative number..that's why i
didn't work..

works fine now :)

thanks TO

--
Message posted from http://www.ExcelForum.com