G
Guest
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!
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!