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.
I've been using Excel for Mac 2011 since it came out. Up until I updated to Yosemite, formatting negative numbers with parentheses appeared in the drop down menu, i.e., right click to get format cells, click number tab on top, click number on left. There is a dialog as to how you want negative numbers formatted.Parentheses used to be an option but no more.p until I updated to Yosemite, formatting negative numbers with parentheses appeared in the drop down menu, i.e., right click to get format cells, click number tab on top, click number on left. There is a dialog as to how you want negative numbers formatted. Parentheses used to be an option but no more.