I am trying to return a 1 if two cells each contain a 10...unfortunately unless I resize my table it is returning a 10 for cells that only contain formula.
I can make it work (i.e. leave it blank when area1change doesn't contain a value, and return 1 if Star 2-score 1 contains 10) for this formula but can't seem to get it right if I want to add that one more cell also has to contain 10:
=IF(AND(ISNUMBER([@[area 1 change]])),IF([@[Star 2 - Score 1]]=10, 1,0),"")
[@[area 1 change]]
and[@[Star 2 - Score 1]]
equal 10?