VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_pinned_comment_I7p6Hzap4qo

I had a difficult time learning IF formula. This video helped a lot! Thanks!

Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊

Thank you so much! Explanation is great and voiceover carries well.

This is by far the most well explained IF statement I have seen.

I never get bored of watching this when I need to re-cap on excel !🧐🇬🇧🤔👍🏻❤️🤓🤓🤓🤝🤝🤝💪🏻💪🏻💪🏻

Amazing video. You have explained every step in details with evidence. Thanks a lot.

You have no idea how much this video has helped me, less than 2mins in i already got what I've been looking for! Keep up the good job, just followed.

Great verbal presentation. Nice pace and repetitiveness; easy to listen to.

I am very lucky to view your videos, very informative, lucid, simple , revealing, thought provoking and realistic. Noble and great job indeed. Great Salute to my Excel teacher/Guru.

The best on this I have seen. Crystal clear as well. well done

Your comfortable pace and stepwise presentation made the learning process a breeze.

This information is very useful I have gain a better understanding, thank you

Thanks you Sir. Clarity explanation, supports me lot

This is exactly what I was looking for, thankyou!

This was very helpful and gave me a much better understanding... thank you for taking the time to post this.🙏🏼

Thank you for your videos Sir. Your videos gave me a much needed refresher on these functions which are very powerful once you know how to use them efficiently. Much much appreciated.

thank you sir. working on a project and my manager expects it shortly. your video is a lifesaver. Cheers!

really u r mindblowing no words to thanks u the content u provide in a single video is above all very appreciated

The tutorial was spot on and helped a lot! I am trying to make the value of a cell change based off of another cell but I’m dealing with dates! So, for example I have one column that gives the status of an individual “expired” or “certified” but I want these cells to change automatically based off of their certification date listed in a separate column! How can I make the value of the status column cells changed based off of a date in a separate column?

thanks for this, i found what i was looking for, nested IF statements 👍🏻❤️ (the formula below, checks E6, & compare it w/ certain range of Nos., and outputs a text appropriate for that) =IF(AND(E6>19,E670,E6128,E6180,E6248,E6

Thank you. This presentation really helped me figure out the formula for my nested IF and Sum function homework that has kept me up all night trying to figure it out. but now I know to add three brackets ))) afterward and it worked. so I ended up having something that looks like these =IF(SUM(C9:H9)=0,0,(SUM(C9:H9))) WHICH I NEVER TAUGHT ABOUT. thank you.

*FIRST!* ♥ Seriously... before I used the Function wizard as a crutch to build IF statements and make sure the syntax was right. I'm gaining in confidence now and certainly wouldn't use the wizard to build simpler IF statement formulas. Thanks for sharing your knowledge!

Fantastic tutorial

Can't thank you enough for this!!!

thank you for the video!!

very useful, thanks

Great video. I hope I'm on the right track, but I'm not sure what my false if values would be in my scenario....So my goal is to keep track of a multitude (250+) of invoices, receipts and payments: (A column or 1) is an entered date, (B column or 2) has the vendor name, (C column or 3) has the $ amount, (D column or 4) has a drop list of subcategories under the main category "fixed", (E Column or 5) has another different drop list of subcategories under another main category "expense", and so on.....can I use the "if" function for different possible choices of entries in a specific row to different tabs within the same worksheet, then use a loop function for the next row of entries? Or would a vlookup be more appropriate? Ex. =if(5,4="fixed",go to "fixed" tab),(5,5="expense",go to "expense" tab),(5,6="income", go to "income" tab),(5,7="loans", go to "loans" tab) Thank you for your clarification :))

This really helped me to prepare for my finals Thank you❤

very helpful for Excel class. ty, nj

Great video! Thank you. 📊

Hi, thanks pls help how to put another cell (not the text specific) as final true argument

Thanks a lot

Very good explanations thank you

Beautiful explanation.... 👍

Very well explained.

I Love your Experience ,Egypt

When I seen your file on Excel mobile, (on windows phone) I noticed that I needed to use =if(A1>=30;"cool";"Not cool")

Amazing and very helpful

If I can only ask my school to replace my teacher right now, I would chose you You are incomparable the way you show on your tutorial video.

Great Tutorial I just one question, I encountered this formula "=IF(N76="OSM","OSM",N76*$O$4)" and was wondering what "OSM" means? Thanks.

thanks so much for this sir i just have a difficulty if in a single cell i will find multiple criteria and will display multiple valu, is if function still be in use?

Last example was nice, never used Nested IF like that. I used a lot of nested IF but I always typed value_if_true for first IF as well

Well done great job thanks

Awesome video... Thanks 👍😇

hello sir. this tutorial is great! can you combine index match with if function?

Hii Can you plz upload some of sumif function or more advance logical functions it will really help me

*Need Help* If I wanted to add a number in a cell, but wanted the field next to it to highlight, would that be an If Formula, or something different? *Just had to ask

Can u please help me to find out that what's the problem with the formula I made to round of (I don't want to use round fn ) =if(right(c9, 1)>=5, c9+10-right(c9, 1), c9-right(c9, 1)) Please help ASAP Thank you

Good day i struggle to find the visual basic on my laptop please assist. And thank you so much for this vedios, they are of great help to me😘

can you use the IF function to test color of different cells?

How is this workbook included? I want to learn if formula using cells in other workbook sheets.

Awesome video. Question, can you include Highlights in the "If" formula. For example, "If X = False, then highlight red" ?.

I have a estimating spreadsheet that I would like to find out if this is even possible Question: Can excel allow a drop down menu where you can choose one from 3-5 of different material categories? Question: If so, when a selection is made then it changes the options available in the next drop down menu based on the previous selection Question: Can I get up to date pricing from several suppliers (3) in real time where Excel compares the difference and inputs the lowest or highest cost into the sheet Example if a sheet of plywood is 29.00 and one of the three suppliers has pricing at 26.00 and I enter that I need 20 sheets would it price out correctly Question: how can I enter the area of a roof and based on the prior formulas would excel create a price sheet or materials list without having to input each value separately? Example: a 30 year shingle has 3 bundles per 100 sq ft but a 40 year shingle has 4 bundles per 100 square ft. Can excel determine which of the two options 3 or 4 to choose based upon the initial questions answered in the drop down menus?

Very helpful 😍😍

Is it possible to link the cell for the "value_if_true"?

$$$amazing video$$$

very helpful

I'd recommend making three distinct answers for each IF statement on the final nested IF statement so you could see how each answer is returned. otherwise, great video

bless this guy! my teacher is absolute garbage.... this guy made it so easy to understand

Thank you

I tried to use your solution but they didn't work on my Office 2019. Between each value I couldn't figure out what the problem was. Finally I did found a solution. I must use the ; sign instead of the , sign. I don't know why this happens but maybe because I'm living in Europe or by some other stupid reason. But thanks anyway for these IF argument solutions.

Hi - How did you get your mouse pointer highlighted in yellow?

so exciting

Can this if function do other thing except true and false.?

Hi iam trying to practise excel through your tutorials, they are very helpful, thank you so much. Help, my laptop does not have a source icon,

Hi wondering if you can help, I'd like to create a statement for my issues and risks template. It issue and risk should be given a ID automatically. So if I have two risks I would like them to be to given the id's 1&2 the same for an issue. What formula would I use please ?

A teacher friend of mine asked me if it was possible to create a calculator program in Excel that adds up money denominations. Example: click on a dollar bill graphic and that adds a dollar, then click on a five-dollar bill graphic that adds 5 more dollars to the amount, and so on. She would like coins to be included as well. She has a electronic device called a "Coin-u-lator" that does this but they are expensive for the number of students she has and not a big budget.

Can and be used in a count if function

OWP+++ excellent.

if you please assist me for an workbook to distribute the available of currency note to each dept. employee ,[ domination sheet for salary ]

Time stamps would greatly help

if A1 < 0 and A1 > 0? for conditional formating means if cell is less than 0 and same cell may be other time more than 0? thanks

I want to be able to run .30 to 1 on excel, please how can I do that ?

In the second to last example, it seems a little odd to have both IF functions display "Bad" if the result of their respective logical test is false. By doing this, it is not immediately apparent which IF function cause "Bad" to be displayed.

Thanks

I have a very tricky if formula. Could you help

Hi! Im struggling with the following formula I would like to use. Column B has got text. With discriptions and names etc. Column B is in a table called (discription) For this column I use the =IF(COUNTIF(discription,''*abc*'',''A'',"") But I want to add another if to this formula for example =IF(COUNTIF(discription,''*123*'',''B'',"") And 3 to for more IF('s) Im stuck, hope someone could give some advice ✌️🙏

can we use 3 "or" conditions?

Hi, I am preparing my inventory sheet and I have 2 columns In-stock inventory and on the way inventory. I wanna use 2 statements in Stock, on the way and out of stock. Please help

Hello, are you still teaching Excel, I have a problem trying to use an IF statement in a dropdown lists that contains few dependable cells that the same time will display all results in one cell. Do you think that you can help me with this?

plz make a video account statement from a speific date to a requried date in excell

If c3, c7

18:17 it would seam to me that you could just do a 3 way and funktion there? I would say most nestled if fucntions can be replaced with and or or. And if you are a but smart with it, reversing the sign (say from equal to not equal) can solve it if it a miss match. Really to make the code easier to read and also operate faster. (And yes, speed can actually be a issue sometimes)

Please suggest a formula if date change than amount will be automatically changed.

Tell me 1 thing ki 4 column hai mere paas a.b.c.d. isme a .b.C mein value hai d mein nahi hai to print d.. Is it possible kindly reply

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”

Can you please also do a similar INDEX and MATCH tutorial

How do I make an If statement using cells that have a date and number? For example, If this anniversary date arrives then these two cells revert back to zero.

i need 3 "if functions" in 1 cell. if 0-120, 121-240, 241-360. 0-120 = 1, 121-240 = 2 & 241-360 = 3. How do i type that into excel ?

Can you help with this function, =IF(J3 greater than 10,"1",IF(J3 is greater than 10 or less than 15,"2",IF(J3 greater than 15 or less than 20,"3",IF(J3 greater than 20 or less than 25,"4",IF(J3 greater than 25,"5")))))

I am trying to use the IF then statement to find all of the cells in Excel that contain the text "NO GO" in order to create a separate PDF file with the whole line of Information associated with the NO GO cell. IS the IF then statements only used for numerical? or is it possible to use text?

Can i use 'If', 'vlookup' and 'and' together?

if u had a name col. a gender col.an age column and a range showing dates when persons were present. how can u find the for eg the no of males in 15-19, category or no of females in 15-19 catergory, or similarly 20-24 male or female , 25-29 male or female,30-34 male or female, 35-39, or 40 and above male or female?

Interesting

WHERE CAN I DOWNLOAD THE FILE ?

How to find if cell value is negative value

What if two columns will be interpreted. please help me Ex. c1 is frustration and e1 is instructional- the interpretation is frustration if c1 is instructional and e1 is independent- the interpretation is instructional if c1 is independent and e1 is independent- the interpretation is independent I have two cells to be interpreted please help me out.

Please anybody help How can i use if formula for A1>15"A+",A1>12"A", A1> 10"B+"......

Hi , can you please help me, i need to add vat automatically to my supliers , so if supplier name contains ( google ) for example , i need the excel to apply %20 vat automatically to it