1 Cell 2 Values?

S

Shhhh

Hello All,

Is it possible in excel to have it return two values in one cell separated
by a comma and spaces?

For example I want it to count the number of times in a month the value was
positive and the number of times a value was negative and in the cell I want
it to show

A1: +, -

Is this possible?
Thanks to all,
Shhhh
 
H

Harlan Grove

Shhhh wrote...
Is it possible in excel to have it return two values in one cell separated
by a comma and spaces?

For example I want it to count the number of times in a month the value was
positive and the number of times a value was negative and in the cell I want
it to show

A1: +, -

Is this possible?
Click to expand...

As text, yes.

=COUNTIF(MonthRange,">0")&","&COUNTIF(MonthRange,"<0")

What about times in the month when the value was zero?
 
S

Shhhh

Harlan,

Thanks for your reply... the days that are 0 I want it to ignore. is that
going to complicate things?

Thanks again,
Shhhh
 
L

L. Howard Kittle

HI Shhhh,

=(COUNTIF(A1:A20,"<0"))&"- "&(COUNTIF(A1:A20,">0"))&"+"

This ignores 0's.

HTH
Regards,
Howard
 
S

Shhhh

Hello All,

I'm now working on another section of this same sheet, my question is
related to ths one... is it possible to have one number remain formatted as
a number while the second number is formatted as currency?

I've tried, haven't been able to come up with anything... any thoughts?

Thank you,
Shhhh
 
H

Harlan Grove

Shhhh wrote...
I'm now working on another section of this same sheet, my question is
related to ths one... is it possible to have one number remain formatted as
a number while the second number is formatted as currency?

I've tried, haven't been able to come up with anything... any thoughts?
Click to expand...

You could use a formula like =TEXT(x,"General")&",
"&TEXT(y,"$#,##0.00"), but what you seem to want to do leads to more
problems than it solves. Is there any good reason you're not using two
cells with each number in a separate cell?
 
Top