Question

Write the Libre Office Calc formula to multiply a given number entered in a cell with the following conditions 

• If the cell value is less than 20, then multiply by 1 
• If the cell value is greater than or equal to 20 but less than 40, then multiply by 2 
• If the cell value is greater than or equal to 40 but less than 80, then multiply by 3
• If the cell value is greater than or equal to 80 but less than 100, then multiply by 4. 
• If the cell value is greater than or equal to 100, then display “Enter a value less than 100” Use nested IF function.

Answer 1

Procedure: 

Step 1 – Open a blank work sheet in LibreOffice Calc 

Step 2 – Enter the following details in respective cells

Step 3 – Enter any value in cell A2; then the result will be in cell B2. 

Output:

Cell value	Result
18	18
37	74
115	Enter value less than 100
85	340