Absolute values in formulas
 

Hi!

I have a column with some negative numbers (say, -0.39). I need to convert
them to log 2 values (so, -0.39 log 2). To do this, I set up an equation
2^(the cell). With the positive numbers, this works beautifully, but with the
negative numbers, it interprets them as 2^-0.39. How can I resolve this,
while keeping the positive numbers correct? Additionally, I would be happy
just making them absolute values and filling in the negative numbers myself,
but that doesn't seem to work, either. I have the 2003 edition.

Thanks!

Absolute values in formulas
 

Will this work?

=2^ABS(the cell)

HTH,
Elkar


"hurricanekitti" wrote:

Hi!

I have a column with some negative numbers (say, -0.39). I need to convert
them to log 2 values (so, -0.39 log 2). To do this, I set up an equation
2^(the cell). With the positive numbers, this works beautifully, but with the
negative numbers, it interprets them as 2^-0.39. How can I resolve this,
while keeping the positive numbers correct? Additionally, I would be happy
just making them absolute values and filling in the negative numbers myself,
but that doesn't seem to work, either. I have the 2003 edition.

Thanks!