G
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
then h5 = 0 else h5 =sum(c43:m43)
can anyone help? thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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))
So this formula has to go into H5:
=if(h7<16,0,sum(c43:m43))
J
John C
H5: =(H7>=16)*SUM(C43:M43)
M
MartinW
Hi Gary,
Put this in H5
=IF(H7<16,0,SUM(C43:M43))
HTH
Martin
Put this in H5
=IF(H7<16,0,SUM(C43:M43))
HTH
Martin
G