ExcelBanter - formula problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula problem (https://www.excelbanter.com/excel-discussion-misc-queries/208177-formula-problem.html)

Gary

formula problem

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

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

John C[_2_]

formula problem

H5: =(H7=16)*SUM(C43:M43)
--
** John C **

"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

MartinW[_2_]

formula problem

Hi Gary,

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

HTH
Martin

"Gary" wrote in message
...
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

Gary

formula problem

works great thanks
--
Gary

"John C" wrote:

H5: =(H7=16)*SUM(C43:M43)
--
** John C **

"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

All times are GMT +1. The time now is 04:19 PM.