converting continuous data into binary data

A

Asa_johannesen

Hi.

I was wondering is there is any way for me to convert a list of numbers into
another list of numbers giving me a return of either 1 or 0 depending on
whether the original number was above or below a certain limit. Say if my
numbers were from 0 to 9 and I decide to set the limit at 5 I would get a
list of 0s where the original number was below 5 and 1s where the original
was 5 or more.

Thanks
 
A

Asa_johannesen

Thanks for the swift reply :)

However, that only returns a #NAME? message in the cell (well assuming it's
name in english, it's navn in danish). Am I doing something wrong?

Ta

"Toppers" skrev:
 
T

Toppers

try:

in B1:

=(A1>=5)*1

Asa_johannesen said:
Thanks for the swift reply :)

However, that only returns a #NAME? message in the cell (well assuming it's
name in english, it's navn in danish). Am I doing something wrong?

Ta

"Toppers" skrev:
 
P

Peo Sjoblom

=TAL(A1>=5)


M.v.h.


Peo Sjoblom


Asa_johannesen said:
Thanks for the swift reply :)

However, that only returns a #NAME? message in the cell (well assuming
it's
name in english, it's navn in danish). Am I doing something wrong?

Ta

"Toppers" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top