LinkBack URL
About LinkBacks
This equation gives me #NUM! in the cell when x< 0 although I expect it to give me 1 per the MAX function. If x > 0 , it works as expected. any help?
= MAX(ROUNDDOWN(0.5*((x)^0.5 + 1),0),1)
This equation gives me #NUM! in the cell when x< 0 although I expect it to give me 1 per the MAX function. If x > 0 , it works as expected. any help?
= MAX(ROUNDDOWN(0.5*((x)^0.5 + 1),0),1)
Last edited by tdschulz; 11-09-2012 at 02:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks