The PRODUCT function in Excel is used to calculate the product of the selected values. In other words, it multiplies each of the values selected in Excel.
You can then use the IF logical function to determine which calculation to perform or action to take depending on the outcome of the test. Here are some.