Help with formula please.

[bionicle]

Hi everyone,

Can some one provide some guidance on a formula please. I have a drop down with "group1, group2, group3" in cell J1 and based on that value I need a formula that look at a salary in column J3 that will calculate 20% of that salary, if the sum of that formula is between £4,500 and £7500 then it does nothing but if its under or over it will default to either the £4500 or the £7500. the result needs to be in cell K3

Any help would be appreciated.

 

[Peter_SSs]

I think that this should suffice too?

=MEDIAN(FILTER(O2:O4,N2:N4=J1)*J3,FILTER(P2:Q4,N2:N4=J1))