Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |