MIS Interview Series Q31: Applying IF and OR Functions in Excel
This question demonstrates how to use the IF and OR functions in Excel to determine if a cell's first letter is a vowel, returning 'Start With Vowel' or 'Start ...
RAKESH KUMAR
20 views • Sep 2, 2023
About this video
MIS Interview Series Q31 Use of IF & OR Function<br /><br />=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")<br /><br />=IF(OR(LEFT(A1,1)={"a","e","i","o","u"}),"Start With Vowel","Start with Consonant")<br /><br />Supporting File Link:--<br />https://docs.google.com/spreadsheets/d/1to35CJg90rtQEjRKMcpZJ61ubTfolu6i/edit?usp=sharing&ouid=108365514073073043927&rtpof=true&sd=true
Video Information
Views
20
Duration
6:24
Published
Sep 2, 2023