Empty Cells

[nemish]

I'm looking to do references like

E2: =B2
F2: =C2

But want to do only if there is data
Problem is empty cells in B2 or C2 aren't "empty" they are
",", "0", or "-" and I want them to show as empty cells in the result if that's all they contain

Thanks

 

[T. Valko]

I'm looking to do references like

E2: =B2
F2: =C2

But want to do only if there is data
Problem is empty cells in B2 or C2 aren't "empty" they are
",", "0", or "-" and I want them to show as empty cells in the result if that's all they contain

Thanks

Maybe something like this...

=IF(OR(B2={",","0","-"}),"",B2)

 

[nemish]

Maybe something like this...

=IF(OR(B2={",","0","-"}),"",B2)

Doesn't work for 0 but everything else it worked...
Any thoughts?

 

[T. Valko]

Doesn't work for 0 but everything else it worked...
Any thoughts?

Ok, then remove the quotes from around the zero:

=IF(OR(B2={",",0,"-"}),"",B2)