Question

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 C2 and the price of the object in B2. You are going to put the unit price formula into D2; however, if there is an error, you want the cell to display the message "Cannot divide by zero, please place a value in C2".

What formula should you write in cell D2 to find the unit price and display this message when an error occurs?

Answer 1

To find the unit price of an object, You divide the price by Object.We need to find how much an object cost per unit.

Let, us consider an Example we have 50lbs of Kulfi (Object) that cost 8.00 dollars(price).

To find the Unit cost, We take the 8.00 and divide it by 50, which results in 0.16 cents per pound. We can check this by multiplying 0.16 by 50=8.00

So, Object= Number of units in cell = C2

Price of Object = B2

Unit Price Formula = D2

Therfore, by considering the above example.,

Object = C2 = 50

Price = B2 = 8.00

D2 Formula= Price of Object/ Number of Units

Therfore, The formula for D2 to be placed is D2 = B2/C2.