A
atb
cells at are:
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.
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.