| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula to return one of several values
Have column with dollar values that correspond to fractions representing
thickness of materials (ie cell shows $7.00 - which is the cost of 1/4" material) I want to create another column which will parse the cell with the dollar value and enter the corresponding fractional value for material thickness based on the 6 different cost values that could be in the cell and the related fraction that I want to be populated in the cell of the new column. How do I create this formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to return all non-blank values | Excel Discussion (Misc queries) | |||
| Need a formula to look up 2 values and return result from 3rd colu | Excel Worksheet Functions | |||
| Creating a formula to return a particular result from a Matrix Tab | Excel Discussion (Misc queries) | |||
| conditional formula: return 1 of 4 values | Excel Worksheet Functions | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
Threaded Mode
