Answer:
This seems to be related to MS Excel, here we will discuss the related formula:
<u>=IF(VLOOKUP("Adam Moriarty",$B$3:$C$5,2)>23,"Yes","No")</u>
the name can also be written in adjacent to J2 cell i.e. I2 and its reference to be used in vlookup primary key as follows:
<u>=IF(VLOOKUP(I2,$B$3:$C$5,2)>23,"Yes","No")</u>
Explanation:
We have used simple IF function combined with VLOOKUP function to reference this formula to the table of names and ages of the members (here the table is $B$3:$C$5 and ages are mentioned in 2nd column of the table)
please find attached screenshot for clarification
Answer: Following code is in python
n=input()
num='1'
while int(num)<=int(n): //loop from 1 to n
flag=1 //if an unequal element will be found it will be 0
l=len(num)
if num[0]=='3':
j=0
k=l-1
while j<k: //loop till middle of number
if num[j]==num[k]:
j+=1 //from beginning
k-=1 //from end
else:
flag=0
break
if flag==1:
print(int(num))
num=str(int(num)+1) //number will be incremented as integer
INPUT :
1000
OUTPUT :
3
33
303
313
323
333
343
353
363
373
383
393
Explanation:
In the above code, a loop is executed till num is equal to n which is entered by the user. num is treated as a string so that to ease the process of checking first character is 3 or not. If it is 3 then another loop executes which checks if an element from starting is equal to the corresponding element from the end. If an element is not equal then the flag is changed and then we break out of the loop and prints the number if the flag isn't changed.
While: <span> the loop must repeat until a certain "condition" is met. If the "condition" is FALSE at the beginning of the loop, the loop is never executed. The "condition" may be determined by the user at the keyboard. The "condition" may be a numeric or an alphanumeric entry. <span>This is a good, solid looping process with applications to numerous situations.
</span></span><span>while:<span>int ctr = 1;
while (ctr < = 20)
{
cout<< ctr++ <<"\n";
}
</span><span>
</span><span>
</span><span>HOPE i HELPED! brainliest? :D </span></span>
The
replace text as you type is an option in the AutoCorrect tool that enables the
user to add or delete words that do not follow abbreviation rules. Moreover, this
is a convenient way to use especially if you are dealing with long string of
words that only needs abbreviation.