Forum Discussion
excel formulas
have this formula =if(or(d$11=d$30,d$11=d$31,d$30=d$31),"conflict","okay") which works just fine. Occassionally all the cells are "na" in which case I want "okay" as the result. could you help me modify formula?
1 Reply
Hi Steve,
Do you mean "okay" if all cells are #N/A or any one of them? If the first
=IFERROR(IF(OR(D$11=D$30,D$11=D$31,D$30=D$31),"conflict","okay"),IF(ISNA(D$11)*ISNA(D$30)*ISNA(D$31),"okay","conflict"))
