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 |