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.