I have cells (A1:A5) that have various number values in them. Some of these values may change to zero at a later date.
Question1: In A6, I would like to have a formula that searches A1:A5 to see if one of the values has changed to zero. If so, then I want A6 to show the value found in B1. If not, then A6 can be zero (or blank - it doesn't matter).
I tried this formula but it did not work:
=IF(ISNUMBER(SEARCH("0",A1:A5)),B1,0)
Question 2: In A7, I would like to have a formula that does the same thing as A6, but only if 2 or more of the cells in A1:A5 have been changed to zero.
Thanks in advance for your help.
Bookmarks