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.
Launch Microsoft Excel 2010. Click on a blank cell. Press the Minus sign (-) on the keyboard and immediately press the desired numbers on the keyboard. Press Enter, Tab or an arrow key to save the number, and move to an adjacent cell.Right click on the cell with the negative number displayed.Click Format Cells on the context menu. Click the Number tab and click the desired format name in the left column to display options for that particular number format. Click the desired options for the number on the right.aunch Microsoft Excel 2010. Click on a blank cell. Press the Minus sign (-) on the keyboard and immediately press the desired numbers on the keyboard. Press Enter, Tab or an arrow key to save the number, and move to an adjacent cell.