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.
It is a carryover from Lotus 1-2-3, where formulas can be entered as +123+456 instead of =123+456. Excel permits that form as well. It changes the first to the latter.But it changes +A1+B1 to =+A1+B1 for no good reason that I can think of. In any case, there is no reason to use the +A1+B1 or =+A1+B1 convention.+ isn't really necessary, it's the same as =. In older spreadsheet programs, formulas began with +, e.g. +A1+B1. For compatibility, Excel accepts formulas like that, but because formulas must begin with =, it prefixes an =.