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.
In other words, you will essentially use Ifâ¦then logic statements to build powerful processes that solve your real-life business problems. If you would like to begin learning this and other advanced features of Excel, a good place to start is an advanced online course in Excel. In this guide, we will learn more about what the IF function does, how to use it, and how to get the most out of it by including it within larger formulas. Background on the IF function Like most of the functions you are familiar with in Excel, the IF function delivers an output to a single cell, as opposed to a range of cells (as would be the case for an array function). In using it to process multiple entries throughout a spreadsheet, you construct it for a single cell and then copy it down to additional cells in a range.