Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple answers
In need to us something similar to IF function but to have multiple answers ie
if A3=5 then A5=$9 If A3=6 then A5=$12 IF A3=55 Then A5=$30 Any help would be greatly appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple answers
You could use a lookup. As long as the lookup vector is in ascending order
(ie 5,6,55) in A5, enter =LOOKUP(A3,{5,6,55},{9,12,30}) If you have more numbers to add, you might set up a lookup table. Let's say C1:D10 is the lookup table. Then =LOOKUP(A3, C1:C10, D1:D10) If the lookup vector (or key) isn't in ascending order, look at VLOOKUP. "AndyS" wrote: In need to us something similar to IF function but to have multiple answers ie if A3=5 then A5=$9 If A3=6 then A5=$12 IF A3=55 Then A5=$30 Any help would be greatly appreciated |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple answers
Simple If
=IF(A3=5,9,IF(A3=6,12,IF(A3=55,30,""))) in A5 and format as $ amount. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "AndyS" wrote in message ... In need to us something similar to IF function but to have multiple answers ie if A3=5 then A5=$9 If A3=6 then A5=$12 IF A3=55 Then A5=$30 Any help would be greatly appreciated |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple answers
"AndyS" skrev i en meddelelse
... In need to us something similar to IF function but to have multiple answers ie if A3=5 then A5=$9 If A3=6 then A5=$12 IF A3=55 Then A5=$30 Any help would be greatly appreciated Andy One more way: =INDEX({9,12,30},MATCH(A3,{5,6,55},0)) -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Need help in rounding answers to nearest multiple | Excel Worksheet Functions | |||
How do I make an IF statement have multiple TRUE answers? | Excel Discussion (Misc queries) | |||
MATCH w/ multiple answers? | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions |