Indeed, for some gems, such as diamonds, the price per carat can increase exponentially as the gem size increases. Therefore, a 1 carat stone may cost $1,000 while a 2 carat stone may cost $4,000. This means that good quality sapphires and rubies in larger sizes tend to have a much higher price per carat.
Re: Convert positive # to negative. Hi, if you positive number is in A1, use the following formula to convert it to a negative number =A1*-1 Time values can not be negative. Microsoft MVP http://www.teylyn.com Twitter: http://twitter.com/IngeborgNZ. Microsoft MVP.
If the calculated value is something like â0.000001325, then the value would show with only two digits to the right of the decimal point as â0.00. The negative sign shows, of course, because the internal value maintained by Excel is below zero. There are a couple of ways you can solve this problem. The first is to simply round the calculated value to the desired number of decimal places.