formula problem

[Gary]

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

 

[Dave Peterson]

Formulas return values to the cells that contain them.

So this formula has to go into H5:

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

 

[John C]

H5: =(H7>=16)*SUM(C43:M43)

 

[MartinW]

Hi Gary,

Put this in H5
=IF(H7<16,0,SUM(C43:M43))

HTH
Martin

 

[Gary]

works great thanks
--
Gary

H5: =(H7>=16)*SUM(C43:M43)