contestada

Suppose you are developing an Excel spreadsheet that finds the unit price of any
object. You plan to put the number of units in cell E2, and the price of the object in cell D2.
What formula should you write in a cell to find the unit price?

Respuesta :

MrRoyal

Excel formulas are expressions used to perform computation.

The Excel formula to calculate the unit price of any object is = (D2/E2)

From the question, we have:

  • Cell E2 represents the number of units
  • Cell D2 represents the price of the object

The unit price of an item is the quotient of the price and the quantity.

i.e.

[tex]Unit\ Price = \frac{Price}{Quantity}[/tex]

Replace the variables with the cell names

[tex]Unit\ Price = \frac{D2}{E2}[/tex]

Rewrite as:

[tex]Unit\ Price = D2/E2[/tex]

Remove "Unit Price" from the formula

So, we have:

= D2/E2

This means that the Excel formula to calculate the unit price of any object is = (D2/E2)

Read more about Excel formulas at:

https://brainly.com/question/14820723

Otras preguntas