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.
Select the cell or range of cells that you want to format with a negative number style. How to select a cell or a range. On the Home tab, click the Dialog Box Launcher next to Number. In the Category box, click one of the following: For simple numbers, click Number.For currency, click Currency.elect a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). The first or last cell on a worksheet or in a Microsoft Office Excel table. Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.