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.
Part 2 of 4: Enter Information in Excel. 1. Type values into your spreadsheet. If you are entering a negative number in the cell, place a minus sign before the number. 1  Create a table that uses columns and rows to organize your data. You can also click on the letter at the top of the column or number at the row, to select an entire column or row. 2  Right click on the selected cells and click Format Cells. 3  Click on Number or Currency to indicate what values you will want to subtract.