View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Problem figuring formula

=IF(H20=0,G20,"")
or
=IF(H20=0,G20,"it ain't zero")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MarthaMartha" wrote in message
...
Help. I want cell C20 to populate a formula that is

If cell h20 is $0
then put cell G20 there

I thought it was something like =sum(IF