IF Forumula waddo innawada? Please Help ekak one Saho

[kukku baba]

Ado Excel IF formula help ekak one. Data checks wagayak karanna thiyenawa, Mata danaganna one IF forumla eka me palleha thiyena two scenario welata.

1 Scenario ) Column A eke Rank number eke numerical value eka 1 or 2 wenne one. Habai, Rank number 1 ho 2 nowe nam, B column eke "Invaild" kiyala result eka
denna. If 1 or 2 column B eke "OK" kiyala result eka denna. Hokomada ban me Foruma eka If eken liyanne?

Man poddak kala =If(A2=1,2"OK","Invalid") habai error ekak enawa.

Expected result

2 Scenario ) Column A eke Numerical or Text value ekak thiyennama ona(Mandetory data field), Cell eka empty nam column B eke result eka invalid kiyala denna., Numerical or text value ekak thiyenawa nam OK kiyala result eka denna. Mokakda machan IF Excel Formula eka?

Expected result:

Machan Loku Udavuak. Thanks Wewa Saho.

 

[hodakolla]

BUMPER

 

[thinking_guy]

 

[hasithayad]

1. =IF(A1<=2,"OK","Invalid")

2. =IF(TRIM(A1)="","Invalid","OK")

 

[kukku baba]

View attachment 131996

Thanks for the solution for the first Scenario. Umba nam deiyek.

---

1. =IF(A1<=2,"OK","Invalid")

2. =IF(TRIM(A1)="","Invalid","OK")

Thanks machan, 2nd Senario ekata umbe 2nd proposal eka hari giya. Thanks Wewa saho.
------ Post added on Jun 22, 2021 at 10:07 AM