G
Guest
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.
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.