![]() This formula will be automatically entered into the cell C6 as C6 is the active cell. Now type an equal sign and write this formula: =$B6*C$2. You see the other cells in the range are in grey color (not active). For our selection, cell C6 is the active cell. When you select a range of cells, the first cell becomes the active cell. I will write just one formula in the cell C6 and will use it over cell range C6: E10. What I want is to show the prices of the products in other currencies such as USD, GBP, and JPY. Also, the exchange rates are shown in the cell range C2:E2. The prices of some products (in Euro) are given under the Price (Euro) column. ![]() ![]() You are seeing a sample data in the picture below. Use the method that best suits your purpose. In more than one way, you can apply an Excel formula to multiple cells (cell references will also change). How-to-apply-same-formula-to-multiple-cells-in-ExcelĪpplying the same Excel formula to multiple cells (cell references will change)
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |