count negative cells

chowderhead

New Member
Joined
May 6, 2002
Messages
1
I have a column of both positive and negative Numbers That I would like to count the number of total +numbers as well as the number of -numbers
+number formulas would be in one cell and -number formulas would be in another cell . Can anyone help me with the formulas?
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
On 2002-05-08 11:41, Chris Davison wrote:
for the pure mathematicians :

is "0" positive or negative ?

or is it neither ?

thanks
Chris

According to Merriam-Webster Online m-w.com...

Main Entry: 1pos·i·tive
Pronunciation: 'pä-z&-tiv, 'päz-tiv
Function: adjective
Etymology: Middle English, from Middle French positif, from Latin positivus, from positus, past participle of ponere
Date: 14th century

4e : real and numerically greater than zero<+2 is a positive integer>
This message was edited by Mark W. on 2002-05-08 11:49
 
Upvote 0
[/quote]

According to Merriam-Webster Online m-w.com...

Main Entry: 1pos·i·tive
Pronunciation: 'pä-z&-tiv, 'päz-tiv
Function: adjective
Etymology: Middle English, from Middle French positif, from Latin positivus, from positus, past participle of ponere
Date: 14th century

4e : real and numerically greater than zero<+2 is a positive integer>
This message was edited by Mark W. on 2002-05-08 11:49
[/quote]

According to Bill Gates zero is even.
=iseven(0)

And if that's the way bill wants it, I guess that's the way it is!
 
Upvote 0
On 2002-05-08 11:41, Chris Davison wrote:
for the pure mathematicians :

is "0" positive or negative ?

or is it neither ?

thanks
Chris

Chris, another way of putting it might be to say, 0 is on the fence, on one side of 0 are positive numbers and on the other side of 0 are negative numbers;

You must cross the fence to go from one side to the other -- so if you must change sides, you have got to bear 0's scrutiny!

Regards!
 
Upvote 0

On 2002-05-08 12:26, IML wrote:
According to Bill Gates zero is even.
=iseven(0)

And if that's the way bill wants it, I guess that's the way it is!


Check also

=ISEVEN(-4)

I believe ISEVEN does not allow one to conclude that 0 should be or is a positive integer/number.

Postscript: The loveliest of all programming languages (my bias) LISP has the following predicates:

zerop number

"This predicate is true if number is zero (either the integer zero, a floating-point zero, or a complex zero), and is false otherwise. regardless of whether an implemetation provides distinct representations for positive and negative floating-point zeros,
(zerop -0.0) is always true. it is an error if the argument number is not a number."

plusp number

"This predicate is true if number is strictly greater than zero, and is false otherwise. It is an error if the argument number is not a non-complex number."

minusp number

"This predicate is true if number is strictly less than zero, and is false otherwise. Regardless of whether an implementation provides distinct representations for positive and negative floating-point zeros,
(minusp -0.0) is always false. (the function float-sign may be used to distinguish a negative zero.) It is an error if the argument number is not a non-complex number." [ Steele, G. (1984). Common Lisp: The language, pp. 195-196. ]

Aladin
This message was edited by Aladin Akyurek on 2002-05-08 13:12
This message was edited by Aladin Akyurek on 2002-05-08 13:15
 
Upvote 0
On 2002-05-08 12:35, Aladin Akyurek wrote:

On 2002-05-08 12:26, IML wrote:
According to Bill Gates zero is even.
=iseven(0)

And if that's the way bill wants it, I guess that's the way it is!


Check also

=ISEVEN(-4)

I believe ISEVEN does not allow one to conclude that 0 should be or is a positive integer/number.

Aladin

Agreed, I was just poking fun at Mr Gates. Funny how =iseven calcs on negatives (when it shouldn't?) and cases like =mround(10,-2) (which should seem to be allowed) error out. go figure.
 
Upvote 0
On 2002-05-08 12:59, IML wrote:
On 2002-05-08 12:35, Aladin Akyurek wrote:

On 2002-05-08 12:26, IML wrote:
According to Bill Gates zero is even.
=iseven(0)

And if that's the way bill wants it, I guess that's the way it is!


Check also

=ISEVEN(-4)

I believe ISEVEN does not allow one to conclude that 0 should be or is a positive integer/number.

Aladin

Agreed, I was just poking fun at Mr Gates. Funny how =iseven calcs on negatives (when it shouldn't?) and cases like =mround(10,-2) (which should seem to be allowed) error out. go figure.

Funny how =iseven calcs on negatives (when it shouldn't?)

Ian: In fact, it should. Its counterpart in LISP is evenp.

evenp integer

"This predicate is true if the argument integer is even (divisible by two), and otherwise is false. It is an error if the argument is not an integer." [ Again, from Steele, p. 196 ]

Aladin
This message was edited by Aladin Akyurek on 2002-05-08 13:22
 
Upvote 0

Forum statistics

Threads
1,213,485
Messages
6,113,931
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top