I have the below formulas. They both work well when there's a positive or negative result. However, if the result in R6 is '0', a '1' is placed in both S6 and T6. What I would like is a '0' entered instead. Any ideas?
Cell S6
=IF(R6="","",IF(R6>0,0,1))
Cell T6
=IF(R3="","",IF(R3<0,0,1))
Bookmarks