if formula needed
 

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.

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.

if formula needed
 

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

Hope this helps.
--
John C


"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.

if formula needed
 

=IF(A1B1+B2,MIN(A1-(B1+B2),C3),C3)
--
Regards.
Daniel
"Theresa" a écrit dans le message de
news: ...
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.

if formula needed
 

Hi Theresa

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

--
Regards
Roger Govier

"Theresa" wrote in message
...
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.

if formula needed
 

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

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Theresa

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

--
Regards
Roger Govier

"Theresa" wrote in message
...
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.

if formula needed
 

Hi David

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Roger, are you sure that your formula satisfies the last part of the
requirement:
"If false return value of c3." ?
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Theresa

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

--
Regards
Roger Govier

"Theresa" wrote in message
...
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.