excel-formulaexcel-2010libreoffice-calc
How to divide a cell value by entire row values in excel/libreoffice calc?
How to divide a cell value easily by entire row values in excel/libreoffice calc as like below:
In the image I did manually A2/B1, A2/C1, A2/D1, A2/E1, A2/F1, and same for A3,A4,A5,A6.
Now I need easy shortcut for huge values. Guide me with easy methods. Thanks in advance.
Solution
Use the $ sign to block the Cell references so you can drag the formulas. In your case, place the following formula on cell B2 and then copy it to the rest of the spreadsheet:
=$A2/B$1
You can find more info on the dollar sign on this link.
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Automatic numbering in Excel with hierarchy
- How to do a row-wise sum in an array formula in Excel?
- Transform datatable from column-based to row-based
- Combine most recent 5 records into one cell in Excel
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How do transform a "matrix"-table to one line for each entry in excel
- How to fill fast for integer number calculation?
- Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel - How can we replace multiple characters or whole words in a cell using LAMBDA()
- Nested if statements in EXCEL dependent on first condition
- List only workdays in given dynamic month
- INDIRECT array to refer to a table column not working with array formulas
- Putting a concatenate inside of a count if
- Excel: how to search by two rows and one column
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit
- Custom Excel formula for length restriction of substring within a string in a cell
- COUNTIFS across multiple columns with multiple criteria
- Occurrence by month using Excel Functions
- Strange behavior in Excel when counting Work Hours and Work Super Hours
- Need help fixing my excel formula so it doesn't show #VALUE! error in end result
- Can I guarantee the Image Formula Function is finished before printing the result?
- Excel filter data in date intervals excluding all 0 values
- Count cells with two conditions