Reply to thread

Message: <blockquote data-quote="kukku baba" data-source="post: 26573104" data-attributes="member: 249844">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[ATTACH=full]131991[/ATTACH]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:[ATTACH=full]131992[/ATTACH]Machan Loku Udavuak. Thanks Wewa Saho.</blockquote>

Top Bottom