Calculation with numbers that use measurement units

[Kriman]

Hi,
Can anybody help me.

I am trying to calculate my percentage of profit margin using my cost price and my sell price. The calculation formula is not my problem...my problem is that I would like to write in the cells for "cost" and for "selling price" the measurement units for cost and for selling price.........I would like to write those numbers like this: for cost (10 Kg), for selling price (12 Kg)......then my percentage of profit is 16.6. The 10 Kg means that I paid 10 dollars per kilogram and the 12 Kg means that I sell at 12 dollars per kilogram.

However, I do not know how to write a formula that can disregard the Kg unit and just consider the 10 and the 12, so to calculate the % of profit. My current formula gets an error message when I write in the cell 10 Kg instead of just 10....so, how can I fix this ?

Can anybody help?

[Richard Schollar]

Hi

Rather than actually writing the kg in the cell, just set a custom format - so assuming your numbers in B2:B3, format these numbers via Format>Cells>Number tab and choose a custom format and write it as:

0 "Kg"

and hit OK. This will change how the numbers are displayed, but means that they remain numeric so you can perform calculations on them

Richard