Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me... with Case Structure
1st post here... it's been a WHILE since I've had to do anything in excel so I am very very rusty.... Ok, here is what my spreadsheet is doing: Based on the value of one cell (value is either 1, 2, 3 or 4 only), my projected cashflow for year 1 to year 10 changes. So if the checkvalue is 1, I need to pull certain values from a table to calculate the cashflow, and if the value is 2, I'll need to pull a different set of values for the calculation, and so forth... Am I on the right path here? I have no clue how to implement this... Please help..... :( -- LSB M ------------------------------------------------------------------------ LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258 View this thread: http://www.excelforum.com/showthread...hreadid=560518 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me... with Case Structure
You could use a multiple IF statement, but it sounds as if VLOOKUP
would do what you want more precisely. Read Excel Help, and if it is still not clear then post back with some more detail of what you want to do. Hope this helps. Pete LSB M wrote: 1st post here... it's been a WHILE since I've had to do anything in excel so I am very very rusty.... Ok, here is what my spreadsheet is doing: Based on the value of one cell (value is either 1, 2, 3 or 4 only), my projected cashflow for year 1 to year 10 changes. So if the checkvalue is 1, I need to pull certain values from a table to calculate the cashflow, and if the value is 2, I'll need to pull a different set of values for the calculation, and so forth... Am I on the right path here? I have no clue how to implement this... Please help..... :( -- LSB M ------------------------------------------------------------------------ LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258 View this thread: http://www.excelforum.com/showthread...hreadid=560518 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me... with Case Structure
you're right, vlookup works perfectly. I just happened to recall seeing a spreadsheet years ago with the case function, which looked a but more elegant. Thanks for your help! :) Pete_UK Wrote: You could use a multiple IF statement, but it sounds as if VLOOKUP would do what you want more precisely. Read Excel Help, and if it is still not clear then post back with some more detail of what you want to do. Hope this helps. Pete -- LSB M ------------------------------------------------------------------------ LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258 View this thread: http://www.excelforum.com/showthread...hreadid=560518 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me... with Case Structure
Thanks for feeding back.
Pete LSB M wrote: you're right, vlookup works perfectly. I just happened to recall seeing a spreadsheet years ago with the case function, which looked a but more elegant. Thanks for your help! :) Pete_UK Wrote: You could use a multiple IF statement, but it sounds as if VLOOKUP would do what you want more precisely. Read Excel Help, and if it is still not clear then post back with some more detail of what you want to do. Hope this helps. Pete -- LSB M ------------------------------------------------------------------------ LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258 View this thread: http://www.excelforum.com/showthread...hreadid=560518 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions |