Is it possible that you have something else in F3 or H3 besides numeric
values? Also, if the ratio is < 0.99, do you really want to have it listed
as 0.00 CENTS? Your result will be 2 orders of magnitude smaller than what
it is.

"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.