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.
1 Excel's DATEDIF Function If you regularly work with dates and times in Excel, then it is worth learning how some of Excel's date-related functions operate. 2  There are over 20 functions in this group, â¦. 3  How to Quickly Sum a Column in Excel SUM is one of the commonly used functions in Excel. One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If the valu â¦ e does meet the condition, one result will happen, if false, a different action will occur.