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

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.

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!

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.

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 demo from a business point of view. Thanks a lot!

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

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

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

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

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

Thanks a Million Ralph . This video is extremely helpful.

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

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

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

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

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

Great explanation! Thanks!

Thank you so much for this!!

I love your videos, thank you

Awesome. Glad to hear it.

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

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

amazing just what i was searching for thx :))

Great!!! Very helpful!

I extreeeeeeeeeeeeeeeemely appreciate it! really helpful.

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

Thanks bro, you literally saved my life!

Thank you - Very helpful

Excellent

Thank you master It is very helpfull

thank You very much!

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.

Thx for your help

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

I train Excel and learned a trick

+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!

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

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?

and my problem solved, thanx a lot

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?

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

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.

Thanks Ralph

Informative.

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?

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

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

Great...

Brilliant

thank you Sir

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 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.

I want to be at this level when using excel.

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.

Hey I need your help to my training matrix

Thanks

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?

wow, In this light, you're stunning

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.

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

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

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!

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

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

you kinda look like ibrahimovic

good

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

GReat

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?

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

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

TAKE SOME DISTANCE FROM THE MIC PLEASE

This is too difficult to understand

Dear god man, learn how to use your microphone.