contestada

In cell I5, enter a formula without using a function that divides the General Medicine total in cell H5 by the annual total in cell H9 to display the department’s percentage of total revenue. Use an absolute reference for cell H9, and then enter the same formula without formatting from cell I5 to the range I6:I9.

Respuesta :

MrRoyal

The formula to enter in cell I5 is  = $H$5/H9

How to enter the formula?

The given parameters are:

  • Cell H5 = Medicine Total
  • Cell H9 = Annual Total

To divide H5 by H9, we have

H5/H9

Cell H5 is to be referenced by absolute reference

So, we have:

$H$5/H9

To enter the formula in cell I5, we use the following:

= $H$5/H9

When the same formula is entered in I6 to I9, we have:

= $H$5/H10

= $H$5/H11

= $H$5/H12

= $H$5/H13

Read more about Excel formulas at:

https://brainly.com/question/14299634

#SPJ1

Otras preguntas