Then
=IF(B2<A1,min(C2,A1),0)

--
Regards!
Stefi



€žMark D€� ezt Ã*rta:

Sorry yep that was silly

If B2 is than A1 then the result should be 0

"Stefi" wrote:

Think over your example!
Therefore this should return 2 What is this 2, it doesn't show up in the example.

=IF(B2<A1,min(C2,A1),"whatif B2=A1")

returns C2 if B2<A1 but A1 if C2A1 (won't exceed A1) but you didn't specify
the case B2=A1.

--
Regards!
Stefi



€žMark D€� ezt Ã*rta:

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