PDA

View Full Version : Solved: Using IF command SUM copy paste special

Tenspeed39355
06-24-2009, 04:35 PM
Hi Here is the problem I have run into. I have in Column A a column of numbers. The same for Column B. In column C I am using the IF statement. =IF(B3>A3,"1","0"). If the number in column B is larger I get a
1, if the number in column B is less I get a 0. Here is when the problem comes in. At the bottom of the column I want the SUM. The sum command
will not work because the error message is stating that the 1 or 0 is a text and not a number. I can change the text to a number so the SUM command works by doing a copy paste special but then I loose the formula which I want to keep. My question is how do I keep the formula and get the SUM command to work. Thanks for any help with this one.
Max

GTO
06-24-2009, 06:01 PM
...The sum command will not work because the error message is stating that the 1 or 0 is a text and not a number...

Greetings Max,

Presuming you mean the worksheet function SUM, I don't get an error per se, but the results of the SUM are zero.

I am afraid you lost me a bit when referring to pastespecial, but what would not work with =IF(B3>A3,1,0) ?

Mark

fb7894
06-24-2009, 07:27 PM
Get rid of the quotations in your formula.

=IF(B3>A3,"1","0")

should be

=IF(B3>A3,1,0)

Tenspeed39355
06-24-2009, 08:00 PM
Mark By removing the quotations took care of my problem. Thank you
for your time with the problem. I will rate the thread *****
Max

GTO
06-24-2009, 08:52 PM
Hey Max,

:friends: Very happy to help,

Mark