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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula to return one of several values
For example:
=LOOKUP(A1,{7,8,9,10,11,12;"1/4","1/2","2/3","1","1 and 1/4","1 and 1/2"}) so if A1 contains 12 ( or 12.00) then the formula displays: 1 and 1/2 -- Gary''s Student - gsnu200823 "Lawrence" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula to return one of several values
Not a lot to go on, but you can set up a table like this:
7 1/4" 13 1/2" 19 3/4" 25 1" etc. Suppose you put this in L1:M7, then you can put this formula in B1: =VLOOKUP(A1,L$1:M$7,2) to return the appropriate size, assuming the dollar value is in A1. Hope this helps. Pete On Jan 1, 12:31*am, Lawrence wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula to return one of several values
Hi,
Why don't you show us sample data and what you want it to look like. Parse means break apart and you don't want to break 7.00 apart or do you? This may be what you are looking for: You could create a lookup table with cost in cells H1:H7 and fractions in I1:I7 then =VLOOKUP(A1,H$1:I$7,2,) where A1 contains the value you want to look up, ie. 7.00. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Lawrence" wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula to return one of several values
Thank you very much - this solution worked perfectly!
Happy New Year! "Gary''s Student" wrote: For example: =LOOKUP(A1,{7,8,9,10,11,12;"1/4","1/2","2/3","1","1 and 1/4","1 and 1/2"}) so if A1 contains 12 ( or 12.00) then the formula displays: 1 and 1/2 -- Gary''s Student - gsnu200823 "Lawrence" wrote: 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? |
Reply |
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) |