# Show Blank If Condition Met

• I would appreciate it a lot if someone could explain to me how I hide the value in the cell which a result is stored in when one of the two cells in the calculation is empty.

For exaple:
C1 should be blank if A1 or B1 is empty in this formula:
=A1+B1

GZ

• Re: Hide value

Hello,

In cell C1
=IF(OR(A1="",B1=""),"",A1+B1)

HTH

JL

• Re: Hide value

Thanks a lot.

By the way is there a way to use it with this function

=SUMIF(databas!A:A;C5;databas!B:B)

C5 will always have value so the D5 should be blank if A:A or B:B has no value in the databas sheet

• Re: Hide value

Sorry GZ,

Not sure. I'll have to yield to the experts on that part.

JL

• Re: Hide value

I'm no expert, but does this help?
=IF(OR(databas!A:A="",databas!B:B=""),"",SUMIF(databas!A:A;C5;databas!B:B))

• Re: Hide value

Sorry doesnt work.
Tried it earlier and I am getting, the formula you typed contains an error

• Try Google your Thread Title choice (Hide value) and see just how selfish it is! This forum is all about sharing. Those who ask questions cannot share much, but they should at least try to give back by using a helpful and search friendly Title along with a well written description of the problem.

Please do so in future, just as you agreed to in the rules when joining! Make no mistake, our rules here are enforced and are not hollow.

[COLOR="Red"]REMEMBER:[/COLOR] Your question Title must accurately and concisely describe your problem, NOT what you THINK is your answer and use only relevant keywords.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!