"Jim Thomlinson" wrote:

Why not just use a custom format (Right Click - Format Cell - Number -
Custom) for the cell something like this...

[0.99] $0.00; 0.00¢

Now just use the formula F3/H3 in the cell and it will format the way you
intend... The only difference being that your formula is returning text and
not a number but I should think you want the value to be a number anyways.
--
HTH...

Jim Thomlinson


Jim, that's cause I'm not smart enough to figure that out yet..:)

However, its cleaner, and I do want the Dollar symbols to be added as text
because its not imported into a package I have to do labels...


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