I think the IS... function (ISBLANK,ISNUMBER, etc...) is important because the results can be used in function 'IF'. The data in a cell will be verified before further use.
The test steps - LibreOffice 7.5.2.2
OS: Windows 11 Home
Download from the developer's website: https://www.libreoffice.org/download/download-libreoffice
1. If you don't know how to use function wizard, read the previous post.
ISBLANK, the definition in the app is Returns TRUE if value refers to an empty cell
I show you what this function behaves.
B3 contains formular.
B7 is a blank cell.
Type 456 in B7.
Type gud in B7.
B7 = B9/C9
3. ISERROR
B10 is a blank cell.
B10 = B12/C12 (B12 and C12 are blank cells).
B10 = B12/C12 (B12 = 0 and C12 is a blank cell).
4. ISNA
B13 is a blank cell.
Type #N/A in B13.
B13 contains formular that gives the result #N/A.
In the picture below, cell D19 shows the result of ISLOGICAL(D13) which is TRUE.
Cell D13 shows the result of ISNA(B13)
ISLOGICAL returns TRUE.
ISLOGICAL returns FALSE.
If the value in ISLOGICAL is TRUE or FALSE that comes from the function, ISLOGICAL returns TRUE.
These 5 functions will be helpful for checking values in cells
The test steps - LibreOffice 7.5.2.2
OS: Windows 11 Home
Download from the developer's website: https://www.libreoffice.org/download/download-libreoffice
No comments:
Post a Comment