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 Select the cell C2 and write the formula. 2  The function will return âYesâ or âNOâ. 3  Copy the same formula by pressing the key âCTRL+Câ and paste in to C3:C10 by pressing the key âCTRL+Vâ on the keyboard.xcel allows upto 64 conditions which can be checked in a cell through this function. Syntax of âIFâ function: =if (logical test, [value_if_true], [value_if_false]). Letâs take an example and understand how you can use the IF function to compare dates in excel.