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.
The if statement has three arguments, the first is the condition you want to test (in this case if F6-D6 is less than 0, the second argument is what to do if the condition is true (answer is negative) and the thrid what to do if it is false (answer is positive). Excel Video Tutorials / Excel Dashboards Reports.