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 ...
About this video
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
Video Information
Views
20
Total views since publication
Duration
6:24
Video length
Published
Sep 2, 2023
Release date
About the Channel
Related Trending Topics
LIVE TRENDSThis video may be related to current global trending topics. Click any trend to explore more videos about what's hot right now!
THIS VIDEO IS TRENDING!
This video is currently trending in Kenya under the topic 'betty bayo'.