Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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}) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |