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.
(You can modify the number of decimal places in the format, if necessary.). The other way that you can display negative percentages in red is to use conditional formatting by following these steps: 1  Select the cell (or cells) that may contain negative percentages. 2  Choose Conditional Formatting from the Format menu.3  Leave the first drop-down list set to Cell Value Is. Select the cell (or cells) that may contain negative percentages. 2  Choose Cells from the Format menu. 3  Excel displays the Format Cells dialog box. 4  If the Number tab is not displayed, select it. 5  In the Category list, choose Custom. 6  The dialog box changes so you can enter a custom format.