Hi,

=CR383-IF(CR383-CQ383=0,0.0001,"") gets a value error

The error is the result of the double quotes "", replace with 0.

=CR383-IF(CR383-CQ383=0,0.0001,0)

as for the second part of your problem, you could use an error trap like
"if(iserror(formula),"",formula)" but that would lenghten the formula not
shorten it, one solution might be to make it invisible using conditinonal
formatting with: =ISERROR(A1) and formatting the text white.


HTH
Jean-Guy

"nastech" wrote:

not sure how to fix..
basically have 2 numbers want to subtract, but get DIV/0 Error, (i.e. items
cannot be equal; note: i get if both equal, then nothing, but longer
equation results, below needed for other calculation.. just need to fix 1st
item "trying" below).
thanks...

trying: (finding some numbers are only different by .0001; argh)
=CR383-IF(CR383-CQ383=0,0.0001,"") gets a value error

trying to embed in some fasion, to keep space down, critical. else:

=IF(CR383-CQ383=0,
((CS383-CQ383)/((CR383-0.0001)-CQ383)*10),
((CS383-CQ383)/(CR383-CQ383)*10)) works / is full version of problem

trying to reduce to:
=((CS383-CQ383)/((CR383-IF(CR383-CQ383=0,0.0001,""))-CQ383)*10)