View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
m4goaldad m4goaldad is offline
external usenet poster
 
Posts: 1
Default How do I use a default value or allow data entry to a cell

H2 has a default value of 10. H2 needs to be changeable by a user and the
amount allowed in H2 is infinite, but if H1 = "no" then H2 must equal 0. If
H1 = "Yes" the H2 must equal the amount entered, or if no amount is entered
by user, it must equal the default value of 10. How in the world do I do
that.