Respuesta :

IsrarAwan
The formula is: "=B4/$B$12"

Explanation:
Follow the following steps:

Step-1:
Select the cell C4.

Step-2:
In the "fx" bar at the top, write the following formula:
"=B4/$B$12"

Make sure to add "equal" symbol before B4/$B$12; furthermore, the absolute reference of a cell can be used by using the "$" (dollar) symbol before the cell number. As, in this case, the cell B12 can be represented in terms of absolute reference as $B$12. As you can see that there is a "$" symbol before "12".

Answer:

=B4/$B$12

Explanation:

The first thing is to put the equal sign that indicates that a formula with one or more cells is going to be used. Then, you write B4 that is the numerator, the sign "/" to indicate that the operation is a division and after that, B12 that is the denominator. After this, you have to use an absolute cell reference to cell B12 which means that you need that the formula always refers to the same cell if you move it to other places. In order to do this, after you select B12, you have to press F4 in the formula which will make the $ sign appear to make the cell reference absolute.

Otras preguntas