In a triangle, we use terms like adjacent and opposite. These refer to sides in relation to angles. In our musical triangle, the drummer is at one angle in the back. This side, where the audience is, is called the opposite side.
Trunc is database function, try using round for numeric values, or change the Processing of Query to database.
Image courtesy of Microsoft. TRUNC Function. Type the location of the cell containing the number you want to truncate or click the cell to enter its location automatically. If the number isn't already in another cell, type the number directly into the formula.Add a comma and then type 0 to truncate all decimal places.You can optionally omit this part of the function, as Excel defaults to removing all decimal places. Close the parentheses and press Enter to finish the formula.mage courtesy of Microsoft. TRUNC Function. Type the location of the cell containing the number you want to truncate or click the cell to enter its location automatically. If the number isn't already in another cell, type the number directly into the formula.