Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

divide the value of a column by another column

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

like image 317
Sheik Syed Mohaideen Avatar asked Nov 24 '11 12:11

Sheik Syed Mohaideen


People also ask

How do I divide one column by 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.

How do I divide an entire column by another column in Excel?

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!


1 Answers

Select total_percent / no_of_scren as 'result' From yourTableName
like image 72
Mahmoud Gamal Avatar answered Nov 09 '22 10:11

Mahmoud Gamal