Adding new column with the formula

Follow

Aditya Koyyaamudi

• June 12, 2018 19:51

Hi,

I have two worksheets, one with columns ID, PRODUCT, COST and other sheet with columns  ID,  No of ITEMS SOLD, I have joined both the sheets based on ID and the final worksheet has four columns  ID,  PRODUCT,  COST,  No of ITEMS SOLD.

Now I need to apply formula SALES = COST *  No of ITEMS SOLD and my final Data-set should contain all the five columns i.e. ID,  PRODUCT,  COST,  No of ITEMS SOLD, SALES.

Can someone help me with this

Thaknks

Aditya

0

• 

  Joel Stewart

  • June 12, 2018 20:29

  To do this, simply duplicate the sheet results from the Join sheet and then add a new column with the multiply function like you've included here. The result will contain the 4 columns from the duplication and the newly added 5th column.

  0

  Comment actions Permalink

Please sign in to leave a comment.