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.
Excelâs AND and OR formulas on their own arenât very exciting, but mix them up with the IF Statement and youâve got yourself a formula thatâs much more powerful. In this tutorial weâre going to take a look at the basics of the AND and OR functions and then put them to work with an IF Statement. If you arenât familiar with IF Statements, click here to read that tutorial first. The AND function belongs to the logic family of formulas, along with IF, OR and a few others. Itâs useful when you have multiple conditions that must be met. In Excel language on its own the AND formula reads like this: