To calculate amount based on %

Dear Friends,

PFA the file.

I need to calculate amount in col K.
is there any formula which can calculate the amount since the data is huge and calculating the amount manually is time consuming.

Please assist.

On the proviso the sample data is truly representative of the real data, i.e. the SOL ID column really does contain 1 Total, 2 Total etc. then the below formula in K9 and copied down could work.

Formula:

Please Login or Register  to view this content.

BSB

Wow....
You made my day,,,,
Thanks a ton.

Happy to help

BSB