Question

Business studies, Accountancy and Economics are commerce subjects. Write a formula to check whether text is a commerce subject. If yes, print is a commerce subject, otherwise print is not a commerce subject. Write procedure based on the available hints

Answer 1

Procedure: 

Step 1 – Open a blank work sheet in LiberOffice Calc

Step 2 – Enter the text in the following cells.

Step 3 – Enter the name of subject in A2 and type the formula in B2 and drag it 

= IF (OR (A2= “Business studies”, A2 = 

“Accountancy”, A2= “Economics”), A2 & “is a” & “Commerce Subject”, A2 & “is” & “not a commerce subject”) 

Output:

Subject	Remarks
Malayalam	Malayalam is not a commerce subject
Business studies	Business studies is a commerce subject
Chemistry	Chemistry is not a commerce subject
Mathematics	Mathematics is not a commerce subject
Accountancy	Accountancy is a commerce subject.