Thread: formula problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default formula problem

Formulas return values to the cells that contain them.

So this formula has to go into H5:

=if(h7<16,0,sum(c43:m43))



Gary wrote:

I am trying to create a formula that checks the value of h7 if it is <16
then h5 = 0 else h5 =sum(c43:m43)
can anyone help? thanks
--
Gary


--

Dave Peterson