Hi All,
I am trying to use an IF AND formula to return text based on Logical Values from 6 cells entered below.
Is it possible to have this many logical values for this type of formula?
If all the below cells are "True" should return "Achieve"
If any one of the below cells are "False" should return "Fail"
Below is the Syntax i'm trying to use....
Appreciate your assistance
=IF((AND(C5>=98,C7>=98,C6>=98,C8>=98,C9>=98,C10>=98,)),"Achieve","Fail")
Bookmarks