| View previous topic :: View next topic |
| Author |
Message |
jfarr1978
Newbie
Joined: 13 May 2010
Posts: 1
|
 Posted: Thu May 13, 2010 9:29 am Post subject: Finding Negative Values |
 |
|
| I use OOCalc for my yearly budget... is there an easy way to search for negative values? |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8976
Location: Lexinton, Kentucky, USA
|
| Posted: Thu May 13, 2010 11:29 am Post subject: |
|
|
| Search for the minus sign. |
|
| Back to top |
|
|
stevesaunders
OOo Advocate
Joined: 26 Dec 2009
Posts: 408
|
| Posted: Thu May 13, 2010 7:11 pm Post subject: Sign Function |
|
|
SIGN
Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero.
Syntax
SIGN(Number)
Number is the number whose sign is to be determined.
Example
=SIGN(3.4) returns 1.
=SIGN(-4.5) returns -1.
=IF(SIGN(A1)=-1;A1;"")
_________________
Steve ~ Tennessee USA
Mac OS X 10.6.2 Open Office 3.1 |
|
| Back to top |
|
|
|
