Value of non-numeric characters in a formula

J

Jeff Layman

As pretty much an Excel newbie, why does Excel (97 and 2002) treat a
non-numeric character as having a value of 1 in a =PRODUCT formula? It
treats the same character as a 0 in a =SUM formula.

Make C1 =PRODUCT(A1,B1). Then, e.g put 5 in A1 and 3 in B1. C1 shows 15.
Fine. Now try putting 0 in B1. C1 is now 0. Fine again. Now try putting
an e or a comma in B1. C1 shows 5! Why?
Try the same thing with C1 = SUM(A1,B1). The result will be 8, 5, and 5.

TIA for the explanation. I'm sure it's there somewhere in the Help info,
but I can't see it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieve last non zero value in a range of cells 2
Looking to added up based on a character from cell range 1
somewhat complicated conditional formula 2
Help with determining # of days from certain dates 2
Countifs with different restrictions 1
sum values from range of cells if cells correcponding have the sam 15
Baffeling IF statement 7
Subtracting From Multiple Cells Until 0 1

Top