List:General Discussion« Previous MessageNext Message »
From:<critters Date:September 1 2004 10:59am
Subject:A question of negative numbers..
View as plain text  
Hi,
I have a query that returns a list of numbers ranging from -10 to +10

I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also 5, so
in effect all the negative (and only the negative) results are made positive to find the
deviation from zero.

so
5, 4, -3, 4, -1, 0

would become
5, 4, 3, 4, 1, 0

I have been searching for if then else in google so I could do if a < 0 then a = 0-a
but no joy. is there a function to make negative numbers positive?
Thread
A question of negative numbers..critters1 Sep
  • Re: A question of negative numbers..Mikhail Entaltsev1 Sep
  • Re: A question of negative numbers..Alec.Cawley1 Sep
  • Re: A question of negative numbers..Khazret Sapenov1 Sep
  • Re: A question of negative numbers..Michael Stassen1 Sep
RE: A question of negative numbers..critters1 Sep