"Day 8: Excel Essentials Unveiled - Sharing Today's Insights on My Learning Adventure! 📊🚀 #ExcelSkills #LearningJourney"

EXCEL - 7

LOGICAL OPERATORS & FUNCTION : -

AND
OR
NOT
XOR
IF
IFS
IFERROR
IFNA
TRUE
FLASE

LOGICAL :-

= - equal to

<> - not equal to

• greater than

< - lesser than

= - greater than equal to

<= - lesser than equal to

AND
=AND(condition1, condition2, ...)

OR
=OR(condition1, condition2, ...)

NOT
=NOT(logical)

XOR
=XOR(condition1, condition2)

IF
=IF(logical_test, value_if_true, value_if_false)

IFS
=IFS(condition1, value1, condition2, value2, ...)

IFERROR
=IFERROR(formula, value_if_error)

IFNA
=IFNA(formula, value_if_na)

TRUE
=TRUE()

FLASE
=FALSE()

CONDITION

IF - one condition we can also use for multiple conditions with our knowledge.
IFS - It takes multiple inputs ( condition).

LEARNING IS AN EVERYDAY PROCESS SO, i will be updating previous learning with new tips and tricks.

Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46

Thank you for your time.