Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logiacl function with multiple conditions
I am trying to write a formula to calculate points based on % change YOY. The following are the award levels: 2 – 4.99% 5 – 9.99% 10 +% 2 pts 5 pts 10 pts I aml ooking for the best way to write this into a logical statement. Any suggestions would be greatly appreciated! -- stellarblue11 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logiacl function with multiple conditions
Create a lookup table Eg A B 1 0 ' 2 2 2 pts 3 5 5 pts 4 10 10 pts Include a space in Cell B1 otherwise it returns a 0 If the value you want to reference is in cell d1 use =VLOOKUP(D1,$A$1:$B$4,2) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=544891 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logiacl function with multiple conditions
I understand your suggestion, but wouldn't I have to include a lookup for evey possible option? Wouldn't an IF or an IFAND statement be more appropriate? I would like to be able to just enter one formula to cover all of the percent ranges and point possibilities. Thanks in advance!! -- stellarblue11 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logiacl function with multiple conditions
I dont think so, unless I misunderstood what you want. Try it! Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=544891 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logiacl function with multiple conditions
I tried both and was unfortunately unsuccessful. I am totally confounded by this seemily simple problem! The lookup table, returned only the ', telling me that no matter what % was referencing excel was just recognizing it as 0. The IF statement returned 2 pts for a YOY % change of 146.3%, which was the same problem I was running into initially. Is excel perhaps referencing the value of the % change formula instead of it's result? -- stellarblue11 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use IF function for two conditions | Excel Worksheet Functions | |||
Create a Function similar to multiple IFs | Excel Discussion (Misc queries) | |||
COUNTIF - multiple conditions | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |