You're super super smart and great teacher. I'm learning so much. Thanks for sharing😊

You explained the IF, AND and OR functions very beautifully and simplistically. Helped me start learning it. Please keep it up and also if possible at the end of the video give a simple test scenario that people can practice. This will increase the interest as well.

I have been struggling to get an IF statement embedded with an AND/OR formula. I can now see where I have been going wrong. Thank you for taking the time to share.

Thank you. I'm an Excel novice. Watching you work through (especially the Random Between function) was interesting. Wish I had known about that before. Would surely have saved me a lot of time! Keep them coming!

Excellent explanation. This has been a tough one for me to grasp. I liked how you did the () right away. That’s a helpful hint. Thanks!

Great video. Loved the formula used in calculating Bonus where you used IF, AND & OR functions together.

Hervorragend!! Saved my day and took away quite some headaches. Thanks Ralph!!!

Superb Teacher !!! I'm finally getting the hang of it........BRAVO !!!

Excellent demo from a business point of view. Thanks a lot!

is it possible to use a range in either the =and or the =or function. my function works fine i would just like to try it with a range so i dont have to choose seven cases. thanks.

Excellent tutorials with superb example Thanks so much for posting it keep up good work God bless you :-)

Many thanks to Ralph, very precise explanation, thanks a lot.

Thank you very much I have been searching for this for almost a week. You're very clear and precised.

@shd1981-

6 жыл бұрын

1234barber ,

Wow! A lot going on here, but you made it understandable. Thank you.

Thanks a Million Ralph . This video is extremely helpful.

again thanks, I can solve my problem after watching this. It's great .

This is super-amazing stuff. Million thanks for sharing.

Great video..I corrected the years of service by changing cell format to numbers....

Awesome. Glad to hear it.

y'r tutorials are very helpful, keep up this good works thanks

Great explanation! Thanks!

amazing just what i was searching for thx :))

I love your videos, thank you

how do I format a number column based on the letter value of different column

Excellent video, it was exactly what I was looking for Tanks!

Thank you so much for this!!

I extreeeeeeeeeeeeeeeemely appreciate it! really helpful.

Thanks bro, you literally saved my life!

@SixMinutesSmarter

9 жыл бұрын

HKK98 Excellent. I'm going to think all day about the type of situation that could lead to death for not knowing some Excel logic function

@alkhalili1998

9 жыл бұрын

Ralph Phillips LOL we have a test tomorrow so..

@displayname2149

9 жыл бұрын

Ralph Phillips =IF(X>Y,"Z) if it returns "FALSE", the computer explodes.

+Ralph Phillips Hey Ralph, thank you for the videos, they have been a big help. I am having a problem in excel and i cannot find a solution to this problem anywhere. I trade the stock market and i am trying to learn to do my own backtesting for my trading strategies. I am trying to calculate my profit/loss with conditions so basically i need to tell excel "if this happens, then buy at this price, and when this happens, sell at this price". I am having trouble with this and any help would be greatly appreciated! Do you have a video series on anything like this? I cannot find any good demonstrations of backtesting a stock trading strategy. Thank you!

Great!!! Very helpful!

Thank you master It is very helpfull

Hi Ralph, Can I get the data for this so I can follow along? Thanks, Joe, Michigan

Thanks. It helped me a lot. It was exactly what I needed!! :D

i learned stuff even from the set up - what program are you using to record your screen?

Thnx for the video but why do you use c2 or b2 in your formulas instead of c or b1

I am using Excel 2007 and years of service formula is returning bogus data ...is something I am missing? =(Today()-B2)/365.25 is the correct code?

Thank you - Very helpful

Hey I need your help to my training matrix

Hi Raph! Excellent information. I was wondering if you know how to translate this function =IF(OR($J3=99,$J3=98),CC3,VLOOKUP($I3,tbl_wages,6+$J3,FALSE))

I train Excel and learned a trick

thank You very much!

Thx for your help

i need ur help more for this pblm for example: cost of first 20 items rs 4/ item and more than 20 item it cost 9/item. (25item=20*4+5*9 =80+45 =125) for thi case plz help me to find this.

Hi Ralph...this was so helpful. I have a question. I need an IF statement that says...if cell A2= apple and b2 =5 then multiply 2 * c2, but if b2 is greater than 5 and less than 10, then multiply 3 * c2, but if cell A2 = orange and b2 = 6 then multiply 2 * c2, but if b2 is greater than 6 and less than 12, then multiply 4 * c2. It this possible? I tried to use the logic from your tutorial but I hit a dead end.

and my problem solved, thanx a lot

Goshh! You are a life saver!!! ;)

Excellent

Informative.

Thanks Ralph

Good Morning Phillips, here's my dilema. am creating a worksheet that auto populates employee breaks upon entering start and hours worked. Shifts >=10 will get 2 breaks and lunch every 2.5 hrs.

you get many comments commending you, why? Okay let me add mine: thank you for making this didactic lecture.

Great...

Hello Ralph, I am back again. I have this very long weather data and the column for rain seems to show acumulated rain (mm) and the readings stop at 99.9 and start all over again. Is there anyway I can use excel to break down the rainfall for each day? One more thing, Data records for every ten minutes so there are 144 (6*24) rows for each day. I have a feeling it'll involve some kind of looping, does that work with excel?

@SixMinutesSmarter

9 жыл бұрын

sounds like a group and subsort tool. If there is a date value for each 10 minute entry, you can create a field/column for day using the day() function. Then, on the data ribbon use subtotal to provide a subtotal for each change in day for the rainfall value. Before this you may have to make a formula for each cell that looks at the current rainfall minus the previous 10 minute rainfall to get the individual 10-minute amount (not the cumulative).

Ralph, good video, hope you can help me with this one. E1 = 10.00, i need this value to change based on another cell, E1= 11.00 if the value of another cell is 1 E1 = 12.00 if the value in that same other cell is 2, and so on Thanks for the help.

When calculating pay, why do we multiply pay rate by 1.5?

@SixMinutesSmarter

9 жыл бұрын

some business pay employees overtime for going over a certain amount. 1.5 X normal pay for hours over 40 is relatively common for hourly workers. Overtime as it is called is good for employees and expensive for employers, so many managers will work diligently to keep employees from getting overtime.

thank you Sir

Great video m8!! You should invest in a better microphone but thank you so much!

Brilliant

I want to be at this level when using excel.

Hi Ralph. I try the formula =DATA(RANDBETWEEN(2000,2009),RANDBERWEEN(1,12),RANDBETWEEN(1,28)) but did not work. Error your entered to many argument. Can you help me please?

wow, In this light, you're stunning

Thanks

HEY I NEED HELP WITH MY EXCELPROJECT CAN YOU PLEASE HELP ME??

Oh, irony. Me love irony. Me laugh. Ha ha ha ha ha ha ha. That good.

Hello Ralph, have been trying to rearrange a 3 year data set with each date (entered as 10/13/2012) but apparently, I can't fix the day, month and year into seperate columns as 13, 10 , 2012. Pls how do i go about this?

@SixMinutesSmarter

9 жыл бұрын

Excel has functions for day(), month(), and year(). If cell A2 contains the date 10/13/12, then the adjacent cells with =day(A2) =month(A2) =year(A2) will give you the breakdown.

@yadokgodwill2521

9 жыл бұрын

Thanks a lot Ralph. Solves a lot!!! Thanks gain

you kinda look like ibrahimovic

I'm working on improving my Excel skills now. Thanks! But I followed exactly the same, why my equation of "=(today()-B2)/365.25" didn't work out the same result?! please help!!! thanks!

@Tassshi

9 жыл бұрын

after entering that formula of today's date, the result actually comes in the form of date itself, just go to the sub tool of number and change it to number from date, you will get the desired result of 5.48 as stated by Ralph the uploader. Hope that will help.

good

I want to do following calculation Commisiion Calculation Sales upto $1500 = 10% commission Sales upto $2500 = 20% commssion (between 1500-2500) Sales over $2500 = 25% commission How do I put in excel formula?

Hi Ralph, Can you explain how to do this? : IF 100 is > than 40 and < than 200 then its true 

@SixMinutesSmarter

9 жыл бұрын

nest an AND function in the logical test of your if functon: if(and(100>40,100

@awaylabel

9 жыл бұрын

Thank you

GReat

What you say is Ralph is EXCELlent teacher. Ja?

hey, I just got 2 adverts after another. that sux! WUTF youtube O+O

Cool content! It's not needed to check any of my tracks but it would be awesome if you did.

R u teaching or doing yourself!!!!!!!

do you know or you are just teaching

TAKE SOME DISTANCE FROM THE MIC PLEASE

The recording is low quality. Uncomfortable for my ears. Decided to watch a different video on this subject.

This is too difficult to understand

Dear god man, learn how to use your microphone.