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
Please sign in to leave a comment.