MIS Interview Series Q31 Use of IF & OR Function
=IF(OR(LEFT(A1,1)="a",LEFT(A1,1)="e",LEFT(A1,1)="i",LEFT(A1,1)="o",LEFT(A1,1)="u"),"Start With Vowel","Start With Consonant")
=IF(OR(LEFT(A1,1)={"a","e","i","o","u"}),"Start With Vowel","Start with Consonant")
Supporting File Link:--
https://docs.google.com/spreadsheets/d/1to35CJg90rtQEjRKMcpZJ61ubTfolu6i/edit?usp=sharing&ouid=108365514073073043927&rtpof=true&sd=true
=IF(OR(LEFT(A1,1)="a",LEFT(A1,1)="e",LEFT(A1,1)="i",LEFT(A1,1)="o",LEFT(A1,1)="u"),"Start With Vowel","Start With Consonant")
=IF(OR(LEFT(A1,1)={"a","e","i","o","u"}),"Start With Vowel","Start with Consonant")
Supporting File Link:--
https://docs.google.com/spreadsheets/d/1to35CJg90rtQEjRKMcpZJ61ubTfolu6i/edit?usp=sharing&ouid=108365514073073043927&rtpof=true&sd=true
Category
📚
Learning