"atb" wrote:

cells at a
2.5 = f3 / 0.89 = H3.. #value! should be: 0.36

=IF((F3/H3)0.99,TEXT(F3/H3,"$0.00"),TEXT(F3/H3,"0.00¢"))

On another line with same formula: this works

8.3 $1.39 0.17¢

The only thing I can tell is that the second column is not less then $1.00

Please help me with this... thank you.

*******

Figured it out, the problem is: I was using the Text converted version to
do my calculations instead of the intger version of it. dividing f3 as text
... Doh