Excel - Multiple Conditions in IF - Episode 2025

How i get your all videos

In 2016 IFS would be another option.

why the fucking excel is not similar with programming languages??i hate excel because i learn to think for coding purpose

Have you come across the pattern of =switch(true(), test1, result1, test2, result2,....) It allows a series of sequential evaluations of different conditions. A much easier to read pattern over certain types of nested IF statements.

That no function formula blew my mind! Thank you for sharing it. Whoever thought of it is a genius.

Hello, I need a formula which says: If A2 is in column A then call it Red, if A2 is in column B call it Black, if A2 is in column C call it White. Can you please help me?

I'm trying to set up a bracket in excel. For example, IF c3 = Miami, then Miami, IF c7 = Buffalo, then Buffalo, If c11 = Indianapolis, then Indianapolis, If C11 = Tennessee then Tennessee.... It's a 7 team tournament with the top team getting a bye and playing the lowest seed that advances

utilizing if 7, then 7 seed name,
if not 7 then if 6 seed then 6,
if not 6 then if 5 seed then 5,
if not 5 then if 4 seed then 4

Hope this makes sense and appreciate the help. Using City examples for value=value format. Is this possible to set up? Thanks for reading this!

I was wondering the following: I like to participate in soccer bets. Now I would like to make an Excel spreadsheet out of my bets. I’ll try to explain it the best way what I am looking for:

For example:
* COLUMN 1 - ODD = 1.50
* COLUMN 2 - INVESTMENT = $1.50
* COLUMN 3 - WIN OR LOSE

Now if I type WIN, I would like it to automatically calculate the odd * investment in the next column. If I type lose, I would like it to put 0 in the next column. Do you know if this is possible?

Hello there. This was really helpful.

I wanted to ask can this be used for multiple conditions, based on the value in the two columns??

For example, if column A has value " sales" and column B has value "biscuits" then column C should display result " $50". However, if column A has value "Service" and column B has value "bike" column C should display result ""250".
Is this possible?

Hope i was able to explain what i want!!
Thanks in advance 🙂

U r amazing sir, thnk u for ur help.

Thanks a lot for the video. I have Q. , i have three conditions ‘On Leave’, ‘On Duty’, ‘Wating’ and Date From and Date To.. How to solve this, i compared To Date with TODAY() function it didnt work?! How to fix this. Please advise

99.8k subs.. just found your channel and added 1 to that count :) do you have any online classes like on Udemy or something like that?

Which formula used for multiple text criteria.please answer me urgently

Good video, you helped me out with my level three AAT revision there mate!

You just answered a question I've spent weeks finding an answer to and I didn't need to ask.

Hello , Can we make a one equation for multi conditions like the following :-
- if someone have data within a couple of months (date of visit - weight- a score)
we need to find out if he acheived this score or no within 30 days
OR if his weight decreased by a specific percentage within 30 days

Brilliantly explained! Thank you!

hello Mr. Excel,
I am working on a complex IF then statement. I keep getting an error with what I have
=IF(CB3<15,"0",IF(AND(CB3>15,CB3<31),CB3,"1",IF(AND(CB3>30,CB3<61),CB3,"2",IF(CB3>60, “3”))))
I need the function to be within a particular cell if a particular range of numbers is true(i.e., between 31-60, it will provide a value of 2). I can get the individual statements to work but not altogether. Any advice?

Wizard!!!!!

Pls how do I key in multiple “if and” functions without any getting the value error

What if the bonus has multiple tiers like if you get 1000 you can get 10% bonus if you get 20000 you get 20% bonus?

Great video, straight to the point. Thank you so much.

Sounds a little bit like Jeff Goldblum :D

How do I make an IF function that has a greater than, less than, and in between. Ex: IF(B10>75, “High”, IF( B10<25, “Low”)) but I need to include a 75>B10<25, Moderate

straight to the point and solved my issue, thank you sir 🙏

What if two columns will be interpreted. please help me
Ex. c2 is frustration and e1 is instructional- the interpretation is frustration
if c3 is instructional and e3 is independent- the interpretation is instructional
if c4 is independent and e4 is independent- the interpretation is independent

I have two cells to be interpreted please help me out to generate automatically

Please help me
clmn 1 - names & clmn2 - amounts from 10,000 to 50,000
I want to give Diff. bonus @ 1% on amount >20000 but<30000,3% on amount > 30000 but<40000 & 5% on amount > 40000
HOW TO MAKE A FORMULAE ?

this was fantastic! very helpful

Thought this was Matthew McConaughey narrating

now I know what to do when I hate my coworkers

Hi there, I am working in a spreadsheet where I need a different outcome based on If the assumption i do is true or false. The IF formula would allow me to put only the outcome if the IF is true (1) or false(2). is there a formula that link the outcome 1 with the condition 1 and then outcome 2 with assumption 2 etc ?

Perfect Sr! But you put the practice file in every video, please dear

I am having trouble with =if(or(cellA>cellB,cellA<cellB),"over","under") it is always reading "under" despite it should read over? any ideas?

How about if, example: if is China or India, then is 4-Other Asian; if is USA or Russia or Ukraine, then is 1-White, if is Angola or Etiopia then is 2-Black, if is Vietnam, then it is 6-Vietnamese and so forth. I tried to use =IF(OR(A2={"China","India"}),""4-Other Asian",""), so how I add the USA, Russia to give me the 1-White race category?