By the sound of it, you didn't mean DO NOT EXCEED A1, but you presumably
mean DO NOT EXCEED A1-B2 ?
You could use =IF(B2<A1,MIN(C2,A1-B2),"whatever you want if B2=A1")

If the answer you want if B2=A1 is zero, you might try =MEDIAN(0,B2-A1,C2)
but in that case you might want a further trap to deal with cases where C2
is less than zero.
--
David Biddulph


"Mark D" wrote in message
...
Hi Again

I need a formula that does the following

A1 = 41
B2 = 39
C2 = 6

=IF(B2<A1),C2 BUT DO NOT EXCEED A1

Therefore this should return 2

Any ideas

Thank you