equation if zero or nearly zero

  • Thread starter Thread starter melawaisi
  • Start date Start date
M

melawaisi

I have an equation that I am trying to set up, but what I am trying to
do is to take the value of c10 when e10 is either 0 or nearly zero, how
do I do thisIF(E10=0, C10)
 
What is nearly zero ?
Less then 1 ... less then 0.1 ?
What do you want to display if E10 is *not* "nearly" zero ?
 
i have a table with values:

11.734
7.044
4.244
2.714
1.464
0.784
0.361
0.158
0.021
-0.098
-0.173
-0.213
-0.242
-0.2669
-0.2906
-0.3059
-0.319
-0.3294
-0.3377
-0.3439
-0.3484



i would like to add another colum that will take the value that is
closest to zero?
 
One way

=INDEX(A1:A21,MATCH(MIN(ABS(A1:A21)),ABS(A1:A21),0))

array entered with ctrl + shift & enter

will return the value from the list that is closest to zero

Not sure if that's what you want though?
 
One way

=INDEX(A1:A21,MATCH(MIN(ABS(A1:A21)),ABS(A1:A21),0))

array entered with ctrl + shift & enter

will return the value from the list that is closest to zero

Not sure if that's what you want though?
Click to expand...


as will the array-entered:

=MIN(ABS(A1:A20))


--ron
 
Don't know if it's important or not to the OP Ron, but it really *doesn't*
display the *actual* value from the list if the actual value closest to zero
is a negative

Change -0.098 to -0.018, and see what happens.
--


Regards,

RD
 
I knew there was a reason I used that formula <bg>

--

Regards,

Peo Sjoblom


RagDyer said:
Don't know if it's important or not to the OP Ron, but it really *doesn't*
display the *actual* value from the list if the actual value closest to zero
is a negative

Change -0.098 to -0.018, and see what happens.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Click to expand...
 
Back
Top