Is there a way to have a cell, which contains a formula, be classed as a blank cell?

[baljeetgrover]

I am creating excel file in which i want to calculate my online orders to generate profit report. i am getting #value error. I want "L" cell to remain blank if "J" is blank. I know if cell contains formula then it is not considered as blank. Please tell me how can i solve this issue.

Is there a way to have a cell, which contains a formula, be classed as a blank cell?

Or which formula i should use in Cell "L" to keep it blank until i there is numeric value in cell "J" ?

 

[jtakw]

Hi,

The problem is not the cell having a formula, the problem is your formula had put a SPACE " " in the cell, therefore it's not blank, correct your formulas as follows, then you should be fine:

=IF(ISBLANK($I3),"",(G3-H3-I3))
=IF(ISBLANK($J3),"",(J3-K3))

 

[jtakw]

Actually also change them like so:

=IF($I3="","",(G3-H3-I3))
=IF($J3="","",(J3-K3))

 

[baljeetgrover]

Actually also change them like so:

=IF($I3="","",(G3-H3-I3))
=IF($J3="","",(J3-K3))

Thank You so much @jtakw. My Problem is resolved now. Thank u once again

 

[jtakw]

You're welcome, welcome to the forum.

 

[katiapro93]

What if you want a zero to be considered as $0.00 in the formula?

I need to show it as $0.00, but if I write "$0.00), the column next to it with a simple "If" formula saying if both columns match put in "Y', if not put in "N" always gives me "N". if I put "0" on the formula, it doesn't write it as $0.00 and the currency format won't work. Any help?

 

[jtakw]

Please refer to your post here: http://www.mrexcel.com/forum/excel-questions/932591-formulas-not-counted-objects-cell.html