need a simple code
 

Hi
=IF(C1=0,"",C1)

--
Regards
Frank Kabel
Frankfurt, Germany


Peter McCaul wrote:
I'm writing this function in cell e5:

if c1=0, leave blank otherwise display c1.
How would I write this with the proper syntax?

Any help is appreciated.

need a simple code
 

I'm writing this function in cell e5:

if c1=0, leave blank otherwise display c1.
How would I write this with the proper syntax?

Any help is appreciated.