ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/157746-formula-help.html)

clara

Formula Help

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.

clara

Formula Help

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.

All times are GMT +1. The time now is 09:18 AM.