formula
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 |
formula
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 |
All times are GMT +1. The time now is 06:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com