As a combination of both replies, following one could be used as well:
A B (A1:B4)
0 65%
40 70%
65 75%
100 80%
G8= lookup(F8,A1:A4,B1:B4)
Lookup has two options for use and the first one should be used. The format
is: lookup_value, lookup_vector,result_vector
--
R. Khoshravan
Please click "Yes" if it is helpful.
"Ashish Mathur" wrote:
Hi,
Suppose the data below is arranged in range C14:E17
0 39.99 65%
40 64.99 70.0%
65 99.99 75.0%
100 80.0%
In cell G8, you can use the following formula =VLOOKUP(F8,$C$14:$E$17,3)*F8
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Steve" wrote in message
...
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%
If I could get this done it would make my life so much easier. Thanks for
all who has taken a look.