Adding a max value component to existing formula

[Alex D]

Hi...I have this formula here: =5%/INDEX('ICR SLR'!$N:$N,MATCH(E3,'ICR SLR'!$A:$A,0)) and I am trying to add a max value component, where my output will not show more than 300%

 

[dreid1011]

Sounds like you might want to use MIN(). Maybe something like this: =MIN(5%/INDEX('ICR SLR'!$N:$N,MATCH(E3,'ICR SLR'!$A:$A,0)),300%)