| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Help
Thank you so much, that worked perfectly well.
"Ardus Petus" wrote: Say your amount is in H2, percentages in A1:G1 in I2, enter: =H2*INDEX(A$1:G$1,1,MATCH("x",A2:G2,0)) HTH -- AP "Wahine" a écrit dans le message de news: ... Hi there, I have 9 coloumns in a simple spreadsheet that looks like this: 0%, 10%, 25%, 50%, 75%, 90%, 100%, Amount, Converted Amount x $1200 x $750 x $2500 What I need to do is calculate the Coverted Amount as follows: Converted Amount = Amount/the percentage of the row header of the cell with the x in it. Any help on how to write this calculation would be appreciated. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Linear Mode
