dont want subtraction if answer is -ve number

[excellover2212]

I have formula in cell K5 as shown below
=IF(35-K6<=0,0,IF(35-K6>10,0,IF(35-$E6+35-$G6+35-$I6+35-$K6+35-$M6>20,0,35-K6)))
In underlined section there is 35-E6,35-G6, 35-I6, 35-K6, 35-M6
In these sections i want subtraction only if answer is +ve. I have tried IF function but excel does not allow to put if in successive + signs
I am attaching sample file.


resultsample.xlsx

[Chris 53]

Try
=IF(35-K6<=0,0,IF(35-K6>10,0,IF(((35-$E6)*(35-$E6>0))+((35-$G6)*(35-$G6>0))+((35-$I6)*(35-$I6>0))+((35-$K6)*(35-$K6>0))+((35-$M6)*(35-$M6>0))>20,0,35-K6)))

[martindwilson]

35-$E6 so if e6 =35 the result is 0 is that still included?

35-$E6 so if e6 =36 which is -1 is that treated as 0 or 35

[excellover2212]

Dear Sir,
your formula worked well.Thanks for kind attention to my question

[excellover2212]

it should be treated as zero

[excellover2212]

35-$E6 so if e6 =35 the result is 0 is that still included?

35-$E6 so if e6 =36 which is -1 is that treated as 0 or 35

it should be treated as zero

[martindwilson]

in that case
=IF(35-K6<=0,0,IF(35-K6>10,0,IF(175-MIN(35,E6)-MIN(35,G6)-MIN(35,I6)-MIN(35,K6)-MIN(35,M6)>20,0,35-K6)))