Blank Cells = 0...

[gbarelz]

Hi.

I have some cells that contain a certain formula and return a blank cell... and then I have another cell that consists of a formula that includes those blank cells within that cell. I am assuming it doesn't read the cell as a value - which is why it gives me the #VALUE! error. Is there any way/formula I can get around this stupid issue?

Thanks.

 

[jumbledore]

use "iferror" function

 

[gbarelz]

doesn't work. It counts all of these blank cells as cells without a value I think. So lets assume I have a long formula in all a bunch of cells in column B.. and I use column D in which it contains cells that have B2+C2... If i use the "IFERROR" function, i would do the following -IFERROR(B2+C2,"")... so whether a certain cell in column B has or doesn't have a number, it does not read it as a value.