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.
Enter a negative number into an Excel spreadsheet cell by using the minus sign (-) before the number. -12 is an example of a negative number. Use the arithmetic operator, the minus sign (-), to subtract a number using a formula. An example is the formula, =25-10 that will give a result of 15.. Use a function to calculate negative and positive numbers. An example of this is =sum(a1:a3), where cell a1=10, cell a2=12 and cell a3=-25 will give a result of -3.. Use a function to transform a positive result into a negative result by applying the negative sign (-) to the function.