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. |
All times are GMT +1. The time now is 10:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com