OMG you rock. Thank you so much. I have been working on the same example for 3 hrs because I could not figure out the "IF" function when there are words involved. You broke it down perfectly. =0)
@Christian_Villanueva
5 жыл бұрын
Much more helpful than school, thank you sir!
@Maximus-pv9ey
7 жыл бұрын
Thank you, i'm doing my GCSE Business exam in 10 days and this helped a lot =)
@smvelharutyunyan2243
3 жыл бұрын
Thank you, you saved me from informatics homework😂😂
@russellcunning
5 жыл бұрын
Thanks - I use this so rarely that EVER time I want to use it, I have to look it up again!! Even though I only use it rarely, it is a very useful function. The other one I like is 'conditional formatting' - and the same with it... I have to learn it over every time, because as useful as it is, I don't use it often enough to have it stored in my 'wetware' memory (between my ears)!!
@mabast007
6 жыл бұрын
This video was better than the others. Thank you.
@finnjhollett
6 жыл бұрын
Your Better than my GCSE IT Teacher!
@diannewatkins6997
6 жыл бұрын
thank you! really good and simple explanations for the IF function, looking forward to using more of your tutorials to help me along in my spreadsheets and charts class!
@iconicdoll
6 жыл бұрын
Awesome! Really clear explanation! Thanks!
@mudassarnadeem4084
6 жыл бұрын
Sir Plese explain during putting any formula how can I understand where I putt Bracket & comm (," ") as I show on the comment Because I don't know & I Confused my concept not clear about this problem (where_ when_ what) I think You understand pleas upload detail video
@sbmechling
5 жыл бұрын
very helpful way of presenting it. Thank you.
@darlenepassarelli5403
4 жыл бұрын
This is a really great video.....the best I have seen. I am still challenged with making it work for my question though. I need to create a formula where If the dollar amount in a different cell is => 200,000.00 I need to multiply that number by 35%, If under 200,000.00 multiply by 27%. Can you help me with this question?
@jsoutter
5 жыл бұрын
Why does EVERY example of the IF statement include "If it is greater than", then ""? I think it does more than that!
@balusafen6777
5 жыл бұрын
Thanks mah boy!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@hakimakbary65
6 жыл бұрын
I have a little more complicated question. IF A1 is equal to B1 so C1 should be copied to D1. How can we do that? IT will save me a lot of working hours. Can you please help me with that?
@hemanthkumar4870
6 жыл бұрын
Well said sir, I understood the concept.. Pls make more videos on Excel
@softwareschool4114
6 жыл бұрын
Thank you! And I promise I will. :)
@deepahomereview76
6 жыл бұрын
Thank you Sir :) I have understand the formula at the beginning what you have explained and also, I tried with selecting different States and worked it,,, My doubt is how should I think like you,,, means =IF(C6="NJ",J6*10%,"") how to write like this logic !!!! Here I'm lacking,,,,,
@GamerNxUSN
6 жыл бұрын
I have a project that I am to use embedded if functions to display the name of the lowest priced vendor of a product. how do I do this?
@SuperCece100
5 жыл бұрын
This was helpful
@vegancyclistmax8813
5 жыл бұрын
Thanks. The if function is quite easy for me. In scenarios where VLOOKUP and HLOOKUP don’t work, I have been using repeating if functions. Like IF,AA=3,1,IFAA=4,2,IFAA=5,3,3. Is there anyone I can simplify this without having to use if function over and over?
@aaronth07
Жыл бұрын
Excel seems to be unfortunately missing variables for functions, which you would see in other programming languages such as preprocessor Less CSS, Javascript, etc.
@whooperzzz8013
6 жыл бұрын
Thanks a lot !!!
@y9524
5 жыл бұрын
THANK YOU
@jamescline16
7 жыл бұрын
Question, I am trying to create some basketball cards from a game called Statis Pro Basketball. The defense rating for individual players are a difficult thing to gauge. Cool, ok... I have designed a couple of worksheets for a basketball game that I play. I've used basketball reference on line to download my stats and player ratings. The problem I have is before 1974 the NBA doesn't have a individual defensive stats, so I created a matrix and used each teams points against stat as my baseline for assigning defensive ratings to players. I know a bit confusing! Now here is what I want to do. I want to create a cell that when I plug in a number (Boston was 6th in the league in giving up points) let's say 6. Then the spread sheet will go to column 6 and look down the rolls and match it with the 15 players that I have for the team. The players will be assigned 1-15 based on how many times they fouled in the season. Have I lost you? Okay out of those 15 in their order in the 6th column, their will be the ratings for defense that I have: Minus 10 Minus 9 Minus 8 And so on until all 15 are assigned a defensive rating.
@BobFlisser
7 жыл бұрын
If I'm understanding you correctly, you can do this using the VLOOKUP function. But the lookup value (first argument of the function) must be in the 1st column of your data. If you make it the 6th column, the function won't work. If it really must be the 6th column, you can create an intermediary lookup table to shift the column positions.
@jamescline16
7 жыл бұрын
Bob Flisser thanks, I'll try that to see if it works.
@Zenwork
6 жыл бұрын
Thank you ! ;-)
@BobFlisser
6 жыл бұрын
You're welcome! Glad you found it helpful.
@muhammadbashir4121
6 жыл бұрын
what are you doing i dont understand please repeat
@SwschoolTutorials
8 жыл бұрын
For $5 off introductory price (you pay $15), use this link: www.udemy.com/excel90min/?couponCode=FFU0321 Good through 3/23/2016, limited qty available. Course price goes up on 3/25.
@andycruz1204
4 жыл бұрын
This video cannot help you at all or very difficult to understand. The formulas being written are too small in the screen to be able to be read.
@Blasianglamdoll
6 жыл бұрын
I just dont get it
@onetwo234
5 жыл бұрын
find different videos some people don't know how to teach (especially for you personally it might be different)
Пікірлер: 36