removing one... to the greater value...

I'm having with a big little problem.

I am not able to compose a formula that will in the Annex.

the problem is that when the columns are 0 def values in a, b and c, the formula always takes one. and what I am trying to do since yesterday is the following:

if A, B or C are greater than the value of D, E or F, remove one.

Well this is what is formulated to do actually, now that I do not want to go get formula values lower than E, for example. ie count only the highest value among D, E or F.

I hope I have made to understand.

Respects

Try this: =C3-(C3>MAX(F3:H3))

Try this in A6:

=C3 - (C3 > MAX(F3:H3))

EDIT: hat-tip to zbor.

It does same as our formula

hmmm.. Maybe this: =C3-(C3>MIN(F3:H3)) ?

I think they are the same.. Not that you do it wrong.. It was my first solution too.