Replace value in column with another value from same column

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.

Formula.xlsx

Help

Accepted answers

deviseetharaman

Hi,

Please check if this solutions works for you.

Alteryx Calculation.png

Replace value.yxmd

deviseetharaman

Hi @PN2527,

Please find the app that can take user input.

Replace value.yxwz

All comments

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703