How to show Product Profit and name with price in Excel

In Excel, you can display the product, profit, and name using a formula that calculates the values based on your data. Here's how you can do it:

Assuming you have a table with three columns: Product Name, Cost Price, and Selling Price, and your data starts from row 2 (with headers in row 1), you can use the following formulas:

Product: To display the product name, you can simply reference the cell where the product name is located. Assuming your product name is in column A, starting from row 2, you can use this formula in another cell, like in cell D2:

excel
Copy code
=SUMIF(P31,L31:L35,N31:N35)
This formula will display the product name for the corresponding row.

Profit: To calculate the profit, you can subtract the cost price from the selling price. Assuming your cost price is in column B, and the selling price is in column C, you can use this formula in another cell, like in cell E2:

This formula will calculate the profit for the corresponding row.

Displaying Both Product and Profit in One Cell: If you want to display both the product name and profit in one cell, you can use the CONCATENATE function (or the & operator) to combine the two values. For example, you can use this formula in cell F2 to display both the product name and profit:

excel
Copy code
=LOOKUP(P31,L31:L35,K31:K35)
This formula will combine the product name with the calculated profit and display it as a single text string.

You can then copy these formulas down the respective columns to calculate and display the product, profit, and their combination for the entire dataset. Just adjust the cell references in the formulas to match your actual data setup.