| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VB how do I reverse a Negative number?
I have a calculation in Excel Cell that can create a negative zero. I would
like to change the negative to a positive in VB. How can this be done? Rick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VB how do I reverse a Negative number?
Hi Rick,
supposing x=-10 you can use: 1) -x 'to change the sign, if you know that x is always negative 2) abs(x) 'to get always positive number Regards, Ivan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VB how do I reverse a Negative number?
How do you get a negative zero? My understating is that positive and
negative is defined from zero, so zero is neither. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Rick" wrote in message ... I have a calculation in Excel Cell that can create a negative zero. I would like to change the negative to a positive in VB. How can this be done? Rick |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In VB how do I reverse a Negative number?
How can you have a negative 0? Sounds like the display percision is showing a
non-zero as a 0. "Rick" wrote: I have a calculation in Excel Cell that can create a negative zero. I would like to change the negative to a positive in VB. How can this be done? Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse if negative in 2007 | Charts and Charting in Excel | |||
| reverse a number | Excel Discussion (Misc queries) | |||
| Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
| Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Linear Mode
