A number is here but why?

riothecat · #1 06-12-2017, 08:33 AM

I have a formula in a cell that reads a number in another cell.

example. in j293 there is no number but the formula I am using in k293 is producing a negative number. Here is the function; =((J263-40)*(9.25*1.5))+(40*9.25) it is giving me an answer of -185. WHat gives???Thanks in advance

NBVC · #2 06-12-2017, 08:44 AM

Excel sees the blank cell as having value of 0

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find number of coma and then add that number of rows in word using macro?	PRA007	Word VBA	7	05-27-2015 10:45 PM
Number from Barcode and MS Word - formatting number	svuotapista	Word	5	01-30-2015 02:34 AM
How to format a TOC (level 1) using a number, but have the number hidden in the text	porpoiseoil	Word	1	09-13-2014 12:53 PM
Heading's Footnote's number is displayed in TOC. How to remove the number in TOC?	Orehrepus	Word	1	07-13-2014 12:51 PM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM