Learn Excel Functions: Logical Functions (IF, AND, OR, NOT)

By Rajan

Excel functions is used to save the time and effort of user. Excel by default comes with numerous functions to meet the requirement of user, sort data, calculate data by formula, manipulate data etc. Logical functions play a vital role in it. When you are familiar with logical function you can do most of the stuff in excel with very little effort and time.

Why this book?
This book does not make any assumptions about your knowledge in excel. You do not need any prior knowledge to benefit from this book. You will be guided step-by-step starting form where to write formulas, how to write, what is the pre-requisite for each function and how to understand the syntax of functions. All chapters in this book comes with numerous examples for better understanding of logical functions.

What you’ll learn?
IF function
AND function
OR function
NOT function

• Language: English
• Publisher: Rajan
• Release date: Aug 15, 2015
• ISBN: 9781310470288

Rajan

Rajan has been working in Corporate firm and has rich knowledge in scripting and automation tools like VBA, selenium and AutoIT. He has keen interest in developing and programming areas. He loves to automate task which is repetitive and time consuming.His hobbies are blogging, writing and reading books. He is passionate in programming languages and develop useful things out of it. He always love to share known information and knowledge with others.

Book preview

LEARN EXCEL FUNCTIONS

Logical Functions

(IF, AND, OR, NOT)

-Rajan

© Copyright 2015

All rights reserved. No portion of this book may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher.

Contents At A Glance

1.IF Function

2.AND Function

3.OR Function

4.NOTFuntion

1. IF Function

It is one of the most common and powerful Logical functions in excel. It is also useful for evaluating the condition and return output based on it.

Definition of IF function

Job of IF function is to check whether the given conditions met and then it returns one value if the condition is true or another value if the condition is false. However, it should return only one value at a time. You can nest the IF statement but excel allows you