If/AND with multiple cells

How would I find an IF statement if I also need an AND statement? Ex. “If any of the numbers in cells B1, C1, D1 are equal to 5, multiply them together, otherwise add all three”

By: Sarah

Leave a Reply

Your email address will not be published. Required fields are marked *