I want to divide a value of a column by the value of another column and display the result as separate column
ex:
project name total-percent no.of screen ------------ -------------- ------------- pro-1 150 5 pro-2 50 3
now i want to divide total-percent by no.of screen and display the result in another column
Type "=A1/B1" in the formula bar. For example, if you want to divide column A by column B and the first values appear in row 1, you'd use A1 and B1.
To divide columns in Excel, just do the following: Divide two cells in the topmost row, for example: =A2/B2. Insert the formula in the first cell (say C2) and double-click the small green square in the lower-right corner of the cell to copy the formula down the column. Done!
Select total_percent / no_of_scren as 'result' From yourTableName
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With