If Then result if answer is zero

[cableghost]

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))

[63falcondude]

How about these:

S6=IF(R6="","",IF(R6>=0,0,1))

T6=IF(R3="","",IF(R3<=0,0,1))

[cableghost]

Yep, thanks.

[63falcondude]

You're welcome, happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.