How to make AND and OR function using IF function on OpenOffice Calc

How to make AND and OR function using IF function on OpenOffice Calc

Channel:
Indonesia Computertechlighthouse
Subscribers:
613
Published on ● Video Link: https://www.youtube.com/watch?v=J9xMy_iaYqY


Category:
Guide
Duration: 8:24
23 views
0

Hi this is a video about how to make AND and OR function using IF function on OpenOffice Calc.

This is the code from other programming language for AND function:
If A = 0 Then
If B = 0 Then
answer = 0
ElseIf B = 1 Then
answer = 1
EndIf
ElseIf A = 1 then
If B = 0 then
answer = 1
elseif B = 1 then
answer = 1
EndIf
EndIf

This is the function for AND function on OpenOffice Calc:
=if(A2=0;if(B2=0;0;if(B2=1;0));if(A2=1;if(B2=0;0;if(B2=1;1)))

This is the function for OR function on OpenOffice Calc:
=if(A2=0;if(B2=0;0;if(B2=1;1));if(A2=1;if(B2=0;1;if(B2=1;1)))



Other Videos By Computertechlighthouse


2022-03-06How to refill Epson L220 Printer
2022-02-20Rusia and Ukraina and End Times
2022-02-20Live Stream Totz Freelance
2021-11-14SMALL BASIC: How to make program that lists all the folder and subfolders of a defined path
2021-11-13SMALL Basic: Printing Binary Mountain pattern
2021-11-06How to derives sequence formula: 1,1,0,0,1,1,0,0,1,1.. and 1,1,1,0,0,0,1,1,1,...,...
2021-10-30How to referencing cell in OpenOffice Calc
2021-10-29How to generate arithmatic, geometric, and exponential sequences using Openoffice calc
2021-10-29SMALL BASIC: How to create simple encryption and decryption program
2021-10-29How to use conditional formatting on OpenOffice: Change cell's background color, etc.
2021-10-27How to make AND and OR function using IF function on OpenOffice Calc
2021-10-26SMALL BASIC: AND operation calculator
2021-10-03How to solve linear equation (3 equations with 3 variables) with OpenOffice Calc
2021-10-02How to generate 3 linear equations with 3 variables using OpenOffice Calc
2021-09-13Why Telnet traffic isn't secure (Capturing local Telnet traffic using Wireshark)
2021-09-12How to solve EOL Ubuntu's unable to install or update packages: error 404
2021-09-11How to play flash file in 2021
2021-09-09How to pause and unpause OBS recording and set their shortcuts
2021-09-09Installing Windows XP SP 3 in 2021 using VMware player 12
2021-09-08How to fix ADB interface driver error on your computer manually
2021-09-07How to remote controlling android phone from PC using scrcpy


Tags:
AND
OR
IF function
OpenOffice Calc
AND function
OR function