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 this example, the formula will return 0 if cell A1 was either less than 150,000 or greater than 250,000. Otherwise, it will return the value in cell A1. Question: In Microsoft Excel, I'm trying to use the IF function to return 25 if cell A1 > 100 and cell B1 < 200. Otherwise, it should return 0. Answer: You can use the AND function to perform an AND condition in the IF function as follows: