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.
Using a IF function with ELSE in VBA. Using a IF function with ELSEIF and ELSE: in VBA. Hereâs an example of the IF function. This piece of VBA code is simply checking whether the condition specified (i.e. 1 > 4) evaluates to TRUE or FALSE.