Two question, numeric code question and subtraction of two columns?

**mgsweden78** · 04-16-2008, 11:03 AM

When I use conditional wizard to sum variables, the answer formats into a numeric code answer. I have formatted the cell to general, number, and every possible option cell format option. It still formats to a numeric code. It seems as if the numeric code answer is coming from dates in the equation like the sum of Dates > March 1, 2008 and < March 31, 2008. Any thoughts?

Second, how do you subtract two columns of numbers? For example b1-c1 to b200-c200 so that the answers go to k1-k200?

Thank you.

**tuph** · 04-17-2008, 11:33 PM

I can't help with this question:

When I use conditional wizard to sum variables, the answer formats into a numeric code answer. I have formatted the cell to general, number, and every possible option cell format option. It still formats to a numeric code. It seems as if the numeric code answer is coming from dates in the equation like the sum of Dates > March 1, 2008 and < March 31, 2008.

but the answer to your second question is to add this formula into cell K1:
=B1-C1
then fill down to cell K200.