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.
Change the cell formatting to make Excel recognize a negative value as a numerical or currency value to perform calculations without errors or incorrect results. 1  1. Start Microsoft Excel, and open a spreadsheet containing negative numbers in the format -100 or (100) and positive numbers in the format 100.. 2. Click the letter at the top of the column containing negative numbers. The column can also contain positive numbers. Clicking the letter highlights the full column.