Thread: Value Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default Value Error

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)