Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|