How can I prevent 0 from showing?

[TWTHOMAS]

I am using this formual:

=IF('Split Names'!I57=30,'Split Names'!E57,"")

When there is no entry however the formula results in a 0 appearing.

Is there something I can add to the formula so when there is not entry it will just be blank
instead of showing the 0?

 

[Special-K99]

=IF(AND('Split Names'!I57=30,'Split Names'!E57<>0),'Split Names'!E57,"")

 

[VoG]

Try

=IF(AND('Split Names'!I57=30,'Split Names'!E57<>""),'Split Names'!E57,"")

 

[TWTHOMAS]

=IF(AND('Split Names'!I57=30,'Split Names'!E57<>0),'Split Names'!E57,"")
​

Perfect! Thanks