Celetek

Celetek Learn Microsoft Excel with ease

06/10/2025

Hello friends and followers. Longest time.

Greetings to you all my followers
12/04/2025

Greetings to you all my followers

Still in the season of love
15/02/2025

Still in the season of love

14/02/2025

Happy Valentine's Day my lovely followers, friends and lovers of Spreadsheets

31/12/2024

Happy New Year friends and followers

This year, I started lots of things for money. Some worked, some started but crashed, some did not even start. Some came...
31/12/2024

This year, I started lots of things for money. Some worked, some started but crashed, some did not even start. Some came but left me with debts and losses. But all the same, I give God the glory for the profits, lessons and losses. We go again 2025 with new methods, strategy and energy. So help us God. Amen

26/12/2024

Merry Christmas to you all my fans.

THE “IFERROR” Function in Excel (Logical Function Conti..)The IFERROR function in Excel is another logical function that...
24/10/2024

THE “IFERROR” Function in Excel (Logical Function Conti..)

The IFERROR function in Excel is another logical function that is used to handle errors in formulas. It allows one to replace any error result with a custom message or value, instead of showing the default Excel error messages like /0!, /A, !, and the rest. This is particularly useful when you're dealing with functions that may fail under certain conditions (such conditions as division by zero or unsuccessful lookups).

The syntax is as follows:

=IFERROR(value, value_if_error)

The formula above can be interpreted as: “If there is no error, run the formula, if there is, do something else”. From the formula, : The expression or formula you wish to evaluate while : The value (or message) to return if the formula results in an error.

Examples

IFERROR(A1/B1, "Division Error")

The formula above says, “If there is no error, divide the value in cell A1 with the value in cell B1, but if there is an error, return – Division Error”.

Sometimes, the error report can be changed to empty or null by adding a double quote such as
IFERROR(A1/B1, " ")
This means that once there is an error, let the response be empty.

Would you like to know more about this function?

゚

AND and OR Logical Functions in Excel Last week, I posted about logical functions in Microsoft Excel. One of the is th...
17/10/2024

AND and OR Logical Functions in Excel

Last week, I posted about logical functions in Microsoft Excel. One of the is the IF function, which has also been discussed. Today, in this post, I will be talking about the AND and OR Logical functions in .

They are logical functions that return either TRUE or FALSE based on the conditions provided. Let me talk about them a little.

AND Function: The AND function checks multiple conditions and returns TRUE . If any condition is false, it returns FALSE. The syntax for writing AND function is =AND(logical1, [logical2], ...)

Logical1, Logical2 are conditions you want to test (comparisons between values or cells). In Excel, one can create up to 255 conditions.

: =AND(B3=”Pregnant”,C3=”Male Child”)

This formula says, “if cell B3 contains the word “Pregnant”, and also cell C3 contains the word “Male Child”, Return/Produce/Display TRUE, then if anyone is not what is stated here, Return/Produce/Display FALSE ”

OR Function: The OR function is presented the same way as the AND function. The only difference is that in the AND function, all conditions must be met but in the OR function, only one condition is required. In other words, the OR function checks multiple conditions and returns TRUE if any of the conditions are true. If all conditions are false, it returns FALSE.

: =OR(C3=”Male Child”,D3=”Female Child”)

The formula above says, “return TRUE if any of the cells contains a MALE CHILD or a FEMALE CHILD

Both the AND and the OR functions are useful in decision-making formulas, especially when combined with IF for more complex logic. For example:

The two functions can be combined with the IF function to make better decisions in data handling.

:

=IF(AND(B5="Pregnant",C5="Male Child"),"Buy Car","Buy House")

Looking at the table in the picture below, the formula says, “If Ukamaka is Pregnant and it is a Male child, buy a car, if not, buy a house”

OR

“If cell B5 contains PREGNANT, and C5 contains MALE CHILD, return, BUY CAR if not, return BUY HOUSE”

If you understand these explanations, then interpret the formula below

=IF(OR(C6="Male Child",D6="Female Child"),"Buy House","nothing")

゚

17/10/2024

Logical Function “IF”

Some time week, I discussed the logical functions where I listed a lot of LOGICAL FUNCTIONS in . Today, I will be discussing the IF function which is one of the functions I listed in the discussion.

The IF function in Excel is a logical function that allows you to perform a test and return one value if the test is true and another value if it's false. It is commonly used for decision-making in formulas, based on certain conditions or criteria. The syntax of IF function has three phases, such as the logical phase, the TRUE value phase and the FALSE value phase. Each of the phases are separated by a comma and all the phases enclosed in bracket.
:

=IF(logical_test, value_if_true, value_if_false)

In the above, we have the equals sign, the IF – of the IF statement followed by an open bracket and then the logical test, value if the logical test is true and the value if the logical test is false.

Logical_test: This is the condition you want to test. It can involve comparisons like >, =60,”pass”,”fail”). The “pass” and “fail” are both enclosed with double quotation.
The formula reads, “if the value in cell D2 is greater or equals to 60, assign “pass”, if not, assign “fail”.

The value if true and the value if false can also be another formula or function such as =IF(D2>=60,Sum(B2,C2),product(B2,C2))
Now, assuming B2 and C2 contains 30 and 12 respectively, what do you think will be the output?

There are other ways IF function can be used such as nested IF.
Nested IF is a condition where there are many IF functions in one formula such as the function for grading.

Assuming the grading system is
80 – 100 = A; 65 – 79 = B; 50 – 64 = C; 35 – 49 = D while Below 35 is F

The nested IF will work as follows using the initial total D2
=IF(D2>=80,"A",IF(D2>=65,"B",IF(D2>=50,"C",IF(D2>=35,"D",IF(D2

The LOGIC of life in Microsoft The in have been one powerful tool used by Excel users and data analysts to simplify...
07/10/2024

The LOGIC of life in Microsoft

The in have been one powerful tool used by Excel users and data analysts to simplify data presentation and enhance decision-making. Tighten your seatbelt, and let us talk about the logical functions.

Logical functions in Excel perform operations based on conditions or criteria. They evaluate if certain conditions are true or false and return results accordingly. These functions help automate decision-making processes in spreadsheets, allowing for efficient .

Common logical functions include IF, which checks if a condition is met and returns a specific value, AND and OR, which combine multiple conditions, and NOT, which reverses a logical value. These functions are powerful tools for creating flexible formulas that react differently depending on the data.

Some of the commonly used are:

(1) IF: Evaluates a condition and returns one value if true and another if false.

Example: =IF(A1 > 10, "Yes", "No")

(2) AND: Returns TRUE if all conditions are true, otherwise FALSE.

Example: =AND(A1 > 5, B1 < 10)

(3) OR: Returns TRUE if at least one condition is true, otherwise FALSE.

Example: =OR(A1 > 5, B1 < 10)

(4) NOT: Reverses the logical value of its argument; returns TRUE if the condition is FALSE and vice versa.

Example: =NOT(A1 > 5)

(5) IFERROR: Returns a value you specify if a formula results in an error; otherwise, it returns the result of the formula.

Example: =IFERROR(A1/B1, "Error")

(6) IFNA: Similar to IFERROR, but specifically catches /A errors.

Example: =IFNA(VLOOKUP(A1, B:C, 2, FALSE), "Not Found")

(7) XOR: Returns TRUE if an odd number of the provided conditions evaluate to TRUE, otherwise returns FALSE.

Example: =XOR(A1 > 5, B1 > 5)

(8) SWITCH: Evaluates an expression against a list of values and returns a result corresponding to the first matching value.

Example: =SWITCH(A1, "Red", 1, "Blue", 2, "Green", 3, "Other")

(9) IFS: Checks multiple conditions and returns a value corresponding to the first TRUE condition.

Example: =IFS(A1 > 90, "A", A1 > 80, "B", A1 > 70, "C")

I will be discussing these functions as this new week progresses. Which of them would you like to learn? Which of them do you often use in your office? Which of them would you like to share your experience with us?

02/10/2024

Trim Function

The in is one of the functions that many underrate its use. It is a function that is used to remove all unnecessary spaces between words or characters.

For instance, if in trying to write Celestine Ugonna Eze, one mistakenly writes Celestine Ugonna Eze. The trim function will remove all the spaces between the words leaving only one space. This is to ensure data validation and format especially when such data is heading to a database.

The syntax is =Trim()

The space in the bracket will then be the cell that contains the phrase or sentence you want to trim.

Address

Umajiocha, Nru
Port Harcourt
40101

Telephone

+2348060439019

Website

Alerts

Be the first to know and let us send you an email when Celetek posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Celetek:

Shortcuts

Share