Replace value in column with another value from same column

[PN2527]

As per the attached excel file, I need to compute values in the 'Unit Cost' (Column D). All the required formulas are mentioned in the attached excel.

Please Note: There are two formulas used to compute this column. The formula for cell highlighted in yellow color is different.

[Bennel_Wilson]

Hi,

I'm sure there should be tons of more materials out there for you to compute. As such, is there any logic to identify which type of materials use which formula. Because, without using such identifiers, I don't think it'd be possible to arrive at the right computation.

Regards

Benn

[PN2527]

Hi Benn,

If you look at the excel sheet, basically only two formulas are used, one for the calculation of unit cost and another is to copy the value from cell D5 to D3. Unit Cost (Amount/Quantity) can be computed easily, I need help in copying the value from cell D5 to D3 for material# 1083.

Also, all materials apart from Material# 1083 use the same formula i.e. Amount/Quantity.

Let me know in case of any other information required.

Thanks!

[deviseetharaman · Accepted solution]

Hi,

Please check if this solutions works for you.

[PN2527]

Hi,

Just another question, can we make the input of 0.044 dynamic. As in we ask user to enter that value and then use it in the calculation. If yes, how? 

Many thanks!

[deviseetharaman · Accepted solution]

Hi @PN2527,

Please find the app that can take user input.

[PN2527]

It works perfectly. Thank you so much.

Your solution was really helpful. Kudos!