Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hi i have a spreadsheet that im doing for the inventory of my restaurant. I
have 300 rows and 5 Columns. My last columns is the total price of each row for each different item. But the problem is i dont want to put a function in each cell individually. Is there a way for me to add a function to all the whole column of E. The function im using is PRODUCT =A8*D8. The only thing that changes in each function is the row number which equals the 8 in this example would there be a way for me to select all of column E and put the function =A*D and it would add the row number automatically ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |