On Feb 16, 10:41*pm, Steve wrote:
Can this be done? Formula for G8
If F8's total is $0-$39.99 than (F8)*65%
If F8's total is $40-$64.99 than (F8)*70%
If F8's total is $65-$99.99 than (F8)*75%
If F8's total is $100+ than (F8)*80%

=F8*lookup(F8,{0,40,65,100},{0.65,0.7,0.75,0.8})