Forum Discussion

Oliullah_Siddique

Brass Contributor

Jun 23, 2022

Solved

Excel Formula

Dear everyone,

Please suggest me a formula for the following:

Thanks in advance.

Book1 - Copy.xlsx10 KB

Oliullah_Siddique
Jun 23, 2022
Thank you very much Mark_My_Words

4 Replies

Mark_My_Words
Copper Contributor
Jun 23, 2022
Hi Oliullah_Siddique

Please try: =IF(AND($E$2=$E$3,$E$3=$E$4),"OK","Not OK")

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!
- Oliullah_Siddique
  Brass Contributor
  Jun 23, 2022
  Thank you very much Mark_My_Words
Detlef_Lewin
Silver Contributor
Jun 23, 2022
Oliullah_Siddique
=COUNTIFS($E$2:$E$4,E2)=3
- Oliullah_Siddique
  Brass Contributor
  Jun 23, 2022
  Thanks a lot Detlef_Lewin