If one or another cell is blank then?

[Darla123]

Hello, I have 3 cells, let's call them A1, B1 and C1. If A1 OR B1 are blank, then I want C1 to be blank too. Otherwise I have the a calculation for C1. What is the best way to accomplish this?

 

[Joe4]

Formula in C1:
=IF(OR(A1="",B1=""),"",calculation here)

 

[Roxxien]

You can put this formula in C1, just complete the specific calculation.

=IF(OR(A1="",B1=""),"","Put your calculation here")

 

[Darla123]

Formula in C1:
=IF(OR(A1="",B1=""),"",calculation here)

You can put this formula in C1, just complete the specific calculation.

=IF(OR(A1="",B1=""),"","Put your calculation here")

These both work perfectly, I feel so silly, thank you!

 

[Roxxien]

It's not a problem, anyone can have some blank on some formula. Glad we could help you.

I hope both work correctly as we did the exact same thing.