Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ODCB Error 1919 and ODCB Error 6 Boblink Setting up and Configuration of Excel 1 January 20th 07 10:18 PM
error bars display Amy Charts and Charting in Excel 1 December 22nd 06 11:22 PM
Error bars-repost NTE Charts and Charting in Excel 3 December 11th 05 06:45 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
#REF error Christen Excel Worksheet Functions 5 November 3rd 04 07:29 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"