Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ODCB Error 1919 and ODCB Error 6 | Setting up and Configuration of Excel | |||
error bars display | Charts and Charting in Excel | |||
Error bars-repost | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
#REF error | Excel Worksheet Functions |