HELP PLEASE!!! "Different kinda of function"
 

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.

HELP PLEASE!!! "Different kinda of function"
 

Steve;233710 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%

If I could get this done it would make my life so much easier. Thanks
for
all who has taken a look.

Try
=LOOKUP(F8,{0,39.99,64.99,99.99},F8*{0.65,0.7,0.75 ,0.8})


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65244

HELP PLEASE!!! "Different kinda of function"
 

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})

HELP PLEASE!!! "Different kinda of function"
 

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.

HELP PLEASE!!! "Different kinda of function"
 

What is the meaning of 3 in the end of your vlookup function?
I thought it is a logical value and could be either true(or omitted) for
close value or false for a exact look.
I have seen this trend in other MVPs replies where they use something
totally different and still get the right answer from the function. In
another reply Gordon replied: I feel safe which I couldn't understand.
--
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.

HELP PLEASE!!! "Different kinda of function"
 

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.

HELP PLEASE!!! "Different kinda of function"
 

The 3 is the column number in the lookup table where the result should
be returned from. It is the third argument - you are confusing this
with the fourth (optional) argument for the function which relates to
exact matches.

Hope this helps.

Pete

On Feb 17, 10:17*am, Khoshravan
wrote:
What is the meaning of 3 in the end of your vlookup function?
I thought it is a logical value and could be either true(or omitted) for
close value or false for a exact look.
I have seen this trend in other MVPs replies where they use something
totally different and still get the right answer from the function. In
another reply Gordon replied: I feel safe which I couldn't understand.
--
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.- Hide quoted text -

- Show quoted text -

HELP PLEASE!!! "Different kinda of function"
 

Oh yest, I was confusing with the 4th argument which is ignored here.
thanks for reminding
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Pete_UK" wrote:

The 3 is the column number in the lookup table where the result should
be returned from. It is the third argument - you are confusing this
with the fourth (optional) argument for the function which relates to
exact matches.

Hope this helps.

Pete

On Feb 17, 10:17 am, Khoshravan
wrote:
What is the meaning of 3 in the end of your vlookup function?
I thought it is a logical value and could be either true(or omitted) for
close value or false for a exact look.
I have seen this trend in other MVPs replies where they use something
totally different and still get the right answer from the function. In
another reply Gordon replied: I feel safe which I couldn't understand.
--
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.- Hide quoted text -

- Show quoted text -

HELP PLEASE!!! "Different kinda of function"
 

You're welcome.

Pete

On Feb 17, 3:19*pm, Khoshravan
wrote:
Oh yest, I was confusing with the 4th argument which is ignored here.
thanks for reminding
--
R. Khoshravan
Please click "Yes" if it is helpful.