Find a string in column A and multiply x into corresponding value in column B

[anujv22]

Sample.JPG


Please check the image for sample.

the Output should be needed up to two decimal places only.



Appreciate your help.

[pjwhitfield]

Im not sure what youre looking for? If youre just wanting to round the answer to two digits then

Please Login or Register  to view this content.

will do it?

[Kamboj]

You can format col B with number & 2 decimal places. Right Click col B & then choose Format Cells, under category choose Number and in Decimal Places use 2.

[anujv22]

Thanks guys for your reply

but my requirement is not so simple , i have around 10000 records which contain lot of information in which one of the row have the string value "Amount" in a column A and Column B contain the actual amount say 25.50.

I want to search this string "Amount" and multiply the column B value by 1.07.

Hope this clarifies.

[Kamboj]

In Col C use this

Please Login or Register  to view this content.

[anujv22]

Thanks for your reply.

but above formula i have to put it in a separate column, what i want to do is search existing colum find "Amount" and do B1*1.07.

Can it be put it into a macro?

[bakerman2]

How about this?

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[k_paresh]

I have a formula
formula.png for which values for certain cells are changing each week and I have to arrive at Net Landed costs.
table.png
I have for each different values that will change the landed costs.
As i understand excel I need to create different worksheets for each week to get correct results. can anybody suggest better way.

Thanks in Anticipation.

[6StringJazzer]

k_paresh, unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

[anujv22]

Thanks a lot

[bakerman2]

Thanks for adding rep points.