if formula needed

[Theresa]

Hello, If A1 is greater than the sum of B1+B2, return the difference of A1
minus the sum of B1+B2 but not greater than the value of C3. If false return
value of c3.

 

[Kevin B]

This should do the trick:

=IF(AND(A1>(B1+B2),A1<C3),A1-(B1+B2),C3)

 

[John C]

=IF(A1>(B1+B2),MIN(A1-(B1+B2),C3),C3)

Hope this helps.

 

[Daniel.C]

=IF(A1>B1+B2,MIN(A1-(B1+B2),C3),C3)

 

[Roger Govier]

Hi Theresa

try
=MIN(C3,A1-B1-B2)

 

[David Biddulph]

Roger, are you sure that your formula satisfies the last part of the
requirement:
"If false return value of c3." ?

 

[Roger Govier]

Hi David

You're quite right. My bad.
Didn't test with values less than B1+B2