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.
How to Use the IF Function in Excel. Excelâs IF operator allows you to perform different operations on spreadsheet cells depending on whether conditions in other cells are logically true or false. The operator can only compare two values, but the user can nest more than one IF in a calculation to carry out more complex steps. The usual mathematical comparison symbols are used: =, <, <=, >, >=, <>. The function can be used to write specific values or text to cells or even carry out calculations.