Since aquamarines are available in large sizes, there is no incremental increase in value per carat for large gems. A 50-carat aquamarine will be worth the same price per carat as a single carat gem of equal quality. The gem price is dependent on clarity, depth of color, and to a lesser extent the purity of color.
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Check Cell Value. As another example of the IF function, you can check the value in a cell, and show âGoodâ if the value is $20,000 or more. For lower amounts, the result is âPoorâ.You can use more than one IF function in a formula too. Instead of just Good or Poor, you can nest a second IF in the formula, to test for a lower amount â $10,000 â and rate those results as âAverageâ. The key to nested IF functions is to put the tests in order of difficulty.1  In this example, 20000 is the highest amount that weâre testing for, so that test comes first.nstead of just Good or Poor, you can nest a second IF in the formula, to test for a lower amount â $10,000 â and rate those results as âAverageâ. The key to nested IF functions is to put the tests in order of difficulty. 1  In this example, 20000 is the highest amount that weâre testing for, so that test comes first.