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

Did you try?? The question is somewhat confusing...
=IF(F41, +(.20*amount), +0)


"john" wrote:

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