| 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.. | critters | 1 Sep |
| • Re: A question of negative numbers.. | Mikhail Entaltsev | 1 Sep |
| • Re: A question of negative numbers.. | Alec.Cawley | 1 Sep |
| • Re: A question of negative numbers.. | Khazret Sapenov | 1 Sep |
| • Re: A question of negative numbers.. | Michael Stassen | 1 Sep |
| • RE: A question of negative numbers.. | critters | 1 Sep |
