Found my error:

This works
=IF($D84=TRUE,MAX(MIN($E$8,5000),50),#N/A)


"Clara" wrote:

Hey guys,

I'm stumped, basically what I'm looking for is:

Minimum contribution $50
Maximum contribution $5000
anything in between, give me the number

Cell E8 contains $600, which, if the formula was right, it would return 600
because it's in between 50-5000, but in this case, returns 50. Any
suggestions?

=IF($D84=TRUE,MAX(MIN($E$8,,5000),50),#N/A)

Thank you in advance.