View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

In cell C18, type

=IF(D180,"7480-8900","")

--
HTH

Bob Phillips

"khan" wrote in message
oups.com...
if D18 0 then c18 =7480-8900
can any one help how to do that.I want 7480-8900 to be shown in D18
only if C18 has value 0.