V vince Feb 9, 2004 #1 Trying not to beat a dead horse. I tried all the formulas . Click to expand... ...
F Frank Kabel Feb 9, 2004 #2 hi Vince try =SUMPRODUCT(((E17>{0,250,499.99})*{0.25,0.1,0.15}))*E17 Frank
B Bill Kuunders Feb 9, 2004 #3 Try this in E18. =(IF(E17<=250,E17*1.25,IF(E17>=500,E17*1.5,E17*1.35))) need to format E18 as currency with two decimals. regards Bill K
Try this in E18. =(IF(E17<=250,E17*1.25,IF(E17>=500,E17*1.5,E17*1.35))) need to format E18 as currency with two decimals. regards Bill K
B Bill Kuunders Feb 9, 2004 #4 as you were enter in e18 =(IF(E17<=250,E17*0.25,IF(E17>=500,E17*0.5,E17*0.35))) to show the percentage only and not E17 plus the percentage regards Bill K
as you were enter in e18 =(IF(E17<=250,E17*0.25,IF(E17>=500,E17*0.5,E17*0.35))) to show the percentage only and not E17 plus the percentage regards Bill K
