if statement to remove a cell that does not show a date

[rentonhighlands]

Hello:
What if statement can I use to remove a date in a cell that has value of 0 but other cells have a date I want to keep.

for example
=IF(cb2+75)=0,''',=CB2+75)

 

[dave2018]

i corrected some typos in your formula. does this help?

=IF(cb2+75)=0,"",CB2+75)

 

[rentonhighlands]

for some reason the formula still has error. It highlights 75 after it gives me error.

 

[dave2018]

sorry, this is it.

=IF(cb2+75=0,"",CB2+75)

But i dont get it, in your if statement, you're logical test says if CB2+75=0.... can anything +75 equal 0???

maybe post some of the data that you're working with to give an example of what you you want to to...