Blank Cells = 0...

gbarelz

New Member
Joined
Jun 23, 2015
Messages
33
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

gbarelz

New Member
Joined
Jun 23, 2015
Messages
33
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,601
Messages
5,597,117
Members
414,126
Latest member
jellevansoelen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top