View Single Post
  #3  
Old 17th April 2007, 10:43 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,408
Default

=if(h12=0,10,h12)

I think this is what you are after if i understand correctly

The formula is saying if h12 = 0 then h12 = 10 otherwise it = h12
Reply With Quote