Here is an easy one for someone smarter than I: If Cell A1=2 and Cell B1=2 and Cell C1=A1+B1, currently equally 4. I am trying to find or create a formula in Cell D1 that would argue:D1=WHEN(A1=10,C1=12) I am trying to get a 12 kicked out in the above scenario. This is similar to an IF statement, but if you plug IF in we know it will return a false value. Any ideas or solutions?
Bookmarks