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 would like a formula that says If number is negative, display text red and If positive then display green.. I know you can make negative numbers red in options, but the spreadsheet is linked to data that changes in real-time and would like it to automatically change.Register To Reply.06-15-2006, 01:45 PM #2.xcel: want neg numbers to show red/pos green via if-then formula. I am trying to have the negative numbers in a cell turn red and positive ones turn green as the values change.