Value error

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

in cell K31 I have this formula.

=IF(SUM(Q30:S30)>59,SUM(Q30:S30),IF(SUM(Q30:S30)>49,SUM(Q30:S30)/2,"
"))*NOT(L31+M31>=1)

but I keep getting a value error.

basically what I am trying to achieve is that if there is a value of more
than 0 in cells L31 and/or M31, then the formula will not put a value in
cell K31.

Appreciate any help.
Mel
 
Didn't I give you a response to a very similar question?
try

=if(l31+m31>0,"",sum(q30:s30)/if(sum(q30:s30>59,1,2))
 
Hi Don,

You kindly gave me help with another similar to this

=IF(SUM(Q30:S30)>59,SUM(Q30:S30),IF(SUM(Q30:S30)>49,SUM(Q30:S30)/2," "))
which is in the cell K31, and I need this to apply provided there is no
value above 0 in L31 or M31

Thanks
Mel
 
I still get the value error?


Mel said:
Hi Don,

You kindly gave me help with another similar to this

=IF(SUM(Q30:S30)>59,SUM(Q30:S30),IF(SUM(Q30:S30)>49,SUM(Q30:S30)/2," "))
which is in the cell K31, and I need this to apply provided there is no
value above 0 in L31 or M31

Thanks
Mel
Click to expand...
 
Back
Top