IF(F4<1.85,"£15",F4*CHOOSE(MATCH(F4,{-1E+300,5,6,7,10,20,30,40}),10,9.4,9.5,8.6,8.6,8,8, 7,1,9,6,4))

hi all
bit stuck on this formula, i want to add a disciount to cell if the
quantity in f4 is greater than one,say 20%,is this possible,hope so please
help
john