Jupiter1Copper ContributorMay 07, 2020Formula #NA ERROR Hi All, I have a small issue with a formula error, hoping someone can help. I HAVE A FORMULA WHICH RELIES ON TWO CELLS HAVING A VALUE EQUAL OR MORE THAN 1. I’VE USED THE FORMULA BELOW WHICH WOR...Show More
mtarlerSilver ContributorMay 07, 2020you are using "ifs" instead of "if" so it is looking at the additional parts as an additional condition. try =if(and(y2>=1,$ag$2>=1),1,"")
Jupiter1Copper Contributor to mtarlerMay 07, 2020mtarler That is Perfect! Thank you for your help 🙂
