Entering formulas

  • Thread starter Thread starter mhenderson
  • Start date Start date
M

mhenderson

I am trying to set up a spread sheet with several
columns. I have put a formula in column "D" row 1 through
4000 as such =IF(C5>=1,"1","0"). I then put values in
cells c5 through c52 that will give me a value of 1 in
cells d5 through d52. This formula works fine. I then
entered a formula in cell J4 to sum c5 through c4000 as
such =sum(c5:c4000). The response I am getting in cell
J4 is 0. Why is it not giving me a sum of 52? If I
change the formula in cell J4 to =sum(d5,d6,d7) it gives
me a total of 3. Is there a conflict between the formulas
in column "d" and the formula in cell j4? If there is is
there some other way to sum column c and put the value in
J4?
 
In your formula:

=IF(C5>=1,"1","0")

you have quotes around the 1 and 0. Excel interprets this as meaning you
want these items to be text rather numeric values. If you remove the quotes
from this formula, your problem should be corrected.

HTH
Mike


--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh
 
Your problem is the quotes:
"2" is a text, a character with zero numeric value. 2 is 2. So 0 is actually
the correct answer. Try
=IF(C5>=1,1,0).

HTH. Best wishes Harald
 
Thanks for your help. Your the best.
-----Original Message-----
In your formula:

=IF(C5>=1,"1","0")

you have quotes around the 1 and 0. Excel interprets this as meaning you
want these items to be text rather numeric values. If you remove the quotes
from this formula, your problem should be corrected.

HTH
Mike


--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh




.
Click to expand...
 
Thanks for your help. Your the best.
-----Original Message-----
Your problem is the quotes:
"2" is a text, a character with zero numeric value. 2 is 2. So 0 is actually
the correct answer. Try
=IF(C5>=1,1,0).

HTH. Best wishes Harald

"mhenderson" <[email protected]> skrev i melding



.
Click to expand...
 
Back
Top