MIS-Interview Series-Q31 (Use of IF & OR Function)

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

MIS-Interview Series-Q31 (Use of IF & OR Function)

R
RAKESH KUMAR

20 Views • Sep 02, 2023

Description

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

Microsoft Excel Course: Advanced Excel Training

https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59