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.
Answers. Best Answer: You just input your numbers with the negative sign and the formula is just: =sum(h14:h34) (based on your above example, that is) In other words, let's say H14 is supposed to be -150. Input -150 in the cell. Etc.There's nothing special about adding the numbers just because there are some negatives.nswers. Best Answer: You just input your numbers with the negative sign and the formula is just: =sum(h14:h34) (based on your above example, that is) In other words, let's say H14 is supposed to be -150. Input -150 in the cell. Etc. There's nothing special about adding the numbers just because there are some negatives.