if formula needed
This should do the trick:
=IF(AND(A1(B1+B2),A1<C3),A1-(B1+B2),C3)
--
Kevin Backmann
"Theresa" wrote:
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.
|