Thread
:
Excel string help
View Single Post
#
3
17th April 2007, 10:43 AM
Shaun
Member
Join Date: Jan 1970
Location: Western Australia
Posts: 3,408
=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
Shaun
View Public Profile
Find all posts by Shaun
Add Shaun to Your Buddy List