View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default excel. if g4h4 i want cell j2 to be 0

In cell J2, put the formula:

=IF(G4H4,0,"")

Am I missing something ?

Regards

Trevor


uk"
wrote in message
...