Excel - IF Function, Multiple Criteria with AND OR XOR functions, Dates, Ranges - Tutorial

How to use excel if function, if with multiple conditions, between ranges using greater than and less than with AND, date comparisons and date ranges.
Functions covered in this tutorial: IF, AND, OR, XOR.
Applicable to: Excel, Google Sheets, Apple Mac Numbers, OpenOffice Calc
#excel #if

[@ksb9469]

Thank you so much! You helped me with one complicated formula that saved my time. Really appreciate it!

[@surrealknyte]

Just wanted to say thanks for taking the time and effort in putting this together, it is very much appreciated!

[@ExcelGoogleSheets]

Thank You!

[@thangaveluraj]

Very good, thanks.. your crystal clear voice is delightful and makes listening more interesting

[@ExcelGoogleSheets]

Thank you! 😃

[@muhammadyusuf1023]

THIS VEDIO VERY CLEAR AND VERY GOOD AC TUALLY YR ALL VEDIOS ARE GOOD BUT SOMETIME DISPLAY PROBLEMS I DO NOT WHY

[@shawnamansfield4510]

Thank You You Provided just the type of example I needed!!!

[@tman212]

This was a great video, I was having an issue comparing dates and I think this will solve my issue....Thank You

[@sathyapillari4194]

You have taught many functions so nicely. Admirable. Thank you. 🙏

[@Thenarayanaclips]

Thanks a lot mate for your wonderful videos. All of your videos are super helpful and easy to understand.

[@ExcelGoogleSheets]

Glad to hear that!

[@BigBMrBenben]

This channel is great and so helpful. Thanks for continuing to put out great content!

[@PritomAhad]

so the question is as such i have a coloum with names of sports so for instance “cricket” “soccer” “chess” “ice hockey” “car race” they want me to use a function so that it’ll show first four words of the single word sports and for the “ice hockey” and “car race” Itll show “ first three letters of first word and first letter of second word” but they want me to use “if” function for it. The coloum that has the names of the sports (both single word and two words” is labelled “sport” and i have to use “if” function, also they said if they add a new name be it “one word” or “two word” sport, the formula i use should produce the desired result? So for if function how to let the system know that the sports with single words should show first four letters while the ones with two words should show “first words first three letters and second words first letter”

[@dondonaldson1684]

Excellent tutorial, thank you!

[@ExcelGoogleSheets]

:)

[@dondonaldson1684]

Is there a way to not return result in a calculated column until other cells are populated? In other words, leave it blank until two operand cells are filled.

[@simonsheridan4947]

Incredibly useful, thank you

[@ExcelGoogleSheets]

Glad to hear it!

[@fvc421]

Man how do I give you money you saved my job

[@DJ-xr6un]

Hi was wondering if you could help me. I want the the function to check if the first cell is >= 1 and then to check if the second cell is =1,C4= 2 and then to check if the second cell is

[@professionalkeys2732]

good knowledge about excel

[@MadhanKumar-pn1fi]

Good, can we add vlookup function too, while doing If (And( function...?

[@martinbuckland5746]

how would i use if function to check the first 3 letters/numbers match not the whole number IE E11-2K E12-2K, i only what to see if E11 and E12 match

[@jayantmane7192]

What should I write if I want 'Yes' for Illinois and CA and no for the rest??

[@MCloutier87]

How do you add more than 1 if statement. So if A3=Food or B3= Food then it returns with 1. But in the same statement you also check if it A3=Games or B3=Games then it's 2. Then allows you to add more like to this.

[@ExcelGoogleSheets]

IFS function kzbin.info/www/bejne/nniYp36Dl5V_ptE

[@samueltienko2741]

I HAVE TWO ARRAYS THAT CONTAIN NUMBERS THAT RANGE FROM 1 TO 30 AND I ASK EXCEL TO LIST THE TRIPLE AMONG THESE NUMBERS THAT ARE SIDE BY SIDE IN EACH OF THESE TWO ARRAYS FROM LEFT TO RIGHT UP AND DOWN AND LIST THEM WRITE WHICH FORMULA SHOULD I USE HELP ME PLEASE

[@ExcelGoogleSheets]

It's not clear what you need. Please make an Excel online file with initial array examples and output desired & share it here.

[@samueltienko2741]

@@ExcelGoogleSheets OK

[@samueltienko2741]

@@ExcelGoogleSheets docs.google.com/spreadsheets/d/1zI5VX4zjQS0CK6WVr_uCFmIMk16khGJ1OKSiHKX5AMQ/edit?usp=sharing

[@jasonburns7102]

I have a list of customers that have different benchmarks. For example; Customer 1 must achieve >95%, and Customer 2 must achieve >99.5%. How would i create a formula that identifies the customer and coordinates the % achievement to red or green?

[@jayantakumarkar5323]

How to write the logical function for a cell containing number rannmge i.e. a cell containng number like this 3.6-3.6

[@katerinamoullotu]

Can you help with what formula to use... if cell a has the following values then fill cell b with matching values 0=0 1=15 2=25

[@ExcelGoogleSheets]

assuming you are on office 365 =IFS(A1=0,0,A1=1,15,A1=2,25)

[@sumeriandays86]

Can I write a function that will return 3 values? Dependable on which of the 3 arguments is met? Plz...

[@ExcelGoogleSheets]

Use VLOOKUP or IFS

[@khemrajrana7322]

Sir I have a question I have 1 Google sheet and I want to 31 column name range in date wise so how to quick name range in Google sheet plz reply

[@phecube]

Can you use AND OR XOR in ‘IFS’ function?

[@ExcelGoogleSheets]

of course

[@TrigTrag24]

How would I add range to values

[@ThinkFutureAcademy]

how to Calculate the PR to PO duration based on the followings: If LOA date is available ignore the PO date and calculate the Cycle time from LOA date less RFQ Date (if RFQ date is missing consider the PR Approval Date) Waiting your reply.

[@martinhellawell]

How do I highlight a range of cells according to the contents of another, in the same range, regardless of whether that cell contains a value OR text? i.e F252:I252 would turn yellow if ANY value OR text is placed in any one of these cells?

[@oliverscheurich9202]

=OR($F252"",$G252"",$H252"",$I252"") In the manager for conditional formatting in field "applies to" enter: =$F$252:$I$252

[@cochranesimon]

Hi! I was wondering, if I have a column of numbers, and the number in each cell is higher than 360-I want to subtract 360, and if it's higher than 720, I want to subtract 720, and if it's higher than 1080, I want to subtract 1080 and so on … how would I code that? Basically, I want to have a column of numbers (degrees°) that tell me to rotate something without including the number of full revolutions. For example: if the amount of rotation is in fact 365°, I only really need to rotate it 5° and likewise, if it's 725° I still only need to rotate it 5°, but I cannot work out how to put this as an equation.

[@ExcelGoogleSheets]

Sounds like you want the MOD function. =MOD(A1,360)

[@cochranesimon]

@@ExcelGoogleSheets Amazing! Thank you very much.

[@Kupirempah]

cheers for this video !!

[@ryanviana9849]

CAN I USE "AND" IN A ARRAYFORMULA?

[@ryanviana9849]

IT DOESNT WORK. YOU HAVE TO USE MULTIPLICATION OF TRUE VALUES

[@ExcelGoogleSheets]

Correct.

[@anujbhardwaj1038]

Can you please share practice file

[@colleenfi9111]

12:45 Marks And Or comparisions

[@gerry8001]

Heel goed uitgelegd, maar misschien iets te snel, ik ben een beginner maar vind het erg leuk.

[@khemrajrana7322]

Nice sir

[@rickflair787]

recheck 20:00 - 21:00

[@Puner54]

Teacher...This the Final Formula for Column 'C' in my little Project: =ARRAYFORMULA(IFS((B2:B15)="","",(B4:B17)-OFFSET(B4:B17,-2,0)10000,"",TRUE,(B4:B17)- Explanation: =ARRAYFORMULA ... Sets up the Array Formula. (IFS ... Starts the IFS Function. ((B2:B15)="","", ... Blanks any Cells in the 'C' Column if any corresponding Cells in the 'B' Column are Empty. (B4:B17)-OFFSET(B4:B17,-2,0)10000,"", ... Blanks any Cells in the 'C' Column of Distraction Arithmetic resulting from Inserting 1 Rows. TRUE,(B4:B17)-OFFSET(B4:B17,-2,0))) ... Provides the Difference between 2 Even Cells or 2 Odd Cells in Column "B". Curious, How would you have done this? Next...I have to figure out how to do the same with the more unusual Formula for Column 'D'. JR . .

[@dthom71]

You should have a member support button $4.99

[@ExcelGoogleSheets]

Thanks for the idea. Now I do www.patreon.com/chicagocomputerclasses

[@coldavenue2325]

12:48 when the and or xor starts

[@hapemokenela7388]

This tutorial was very confusing.