LinkBack URL
About LinkBacks
=IF(I25>0,H26,IF(I25=0,H26,IF(I25<0,H26-1)))
In this formula, the value returned is -1, how can I change the formula so that any negative number will return a value of zero?
=IF(I25>0,H26,IF(I25=0,H26,IF(I25<0,H26-1)))
In this formula, the value returned is -1, how can I change the formula so that any negative number will return a value of zero?
=if(if(i25>0,h26,if(i25=0,h26,if(i25<0,h26-1)))<0,0,if(i25>0,h26,if(i25=0,h26,if(i25<0,h26-1))))
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
IT WORKED!!!!! Thank you very much.Originally Posted by sweep
A more compact option would be:
=MAX(0,IF(I25>0,H26,IF(I25=0,H26,IF(I25<0,H26-1))))
or
=MAX(0,H26-(I25<0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks