Does anyone know - I have an IF statement setup asking if a formula 0, same
formula +.01, same formula. (the formula figures an hourly rate based on a
set gross amount taking into account reg and overtime hourly rates and
returns an hourly rate based on a predetermined gross $ amount.) The idea is
if the formula returnsa 0 or a positive gretaer than 0 then ADD +.01 (penny)
else leave the result alone.) The problem is that if the answer is a negative
# such as (.05) exxcel seems to treat that as being greater than 0 and the
penny extra! How can this be? Any idea how to fix this please? (the formula
looks like this - =IF($J555/($E555+($G555*1.5))
=0,$J555/($E555+($G555*1.5))+0.01, $J555/($E555+($G555*1.5)))