| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thousands of possibilities
What is the best way to do this? I have 6 cells that need to be populated based on the results of 3 different cells. C8 is the beacon score C9 is the year model (could be one of 25 possibilities) C10 is the model code (could be one of 115 possibilities) O5 is the lender (could be one of 9 possibilities) Based on the results of these 3 cells, the values of cells O6, O7, O8, O9, O10 and O11 will be determined. For just one cell a simple IF formula would work but there are so many possible values that could result that I don't know how to approach this project. Macros? Formulas? I'm still a novice at excel so this is tough on me. Ideas? -- sharkfoot ------------------------------------------------------------------------ sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164 View this thread: http://www.excelforum.com/showthread...hreadid=526347 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removal of thousands seperator | Excel Discussion (Misc queries) | |||
| Removal of thousands seperator in downloaded data | Excel Discussion (Misc queries) | |||
| Format to Thousands and x-foot the sum | Excel Worksheet Functions | |||
| need to add/remove characters over thousands of cells | Excel Discussion (Misc queries) | |||
| how do I delete thousands of pictures that are somehow embedded i. | Excel Discussion (Misc queries) | |||
Threaded Mode
