How to use the IF Function in Microsoft Excel - For Beginners

How to use the IF Function in Microsoft Excel - For Beginners

Teacher's Tech

2 года назад

100,832 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Emad Atalla
Emad Atalla - 10.09.2023 21:28

Great but I would like ask about $ sign front of E2 why E2 dosnt have value for $ only F2 Thank you sooo much

Ответить
Balkrishna Rana
Balkrishna Rana - 01.09.2023 06:04

Great explanation. Thank you.

Ответить
soibibo alalibo
soibibo alalibo - 13.08.2023 16:11

Good, please I need a note in excel

Ответить
Mariyamma Thanabalan
Mariyamma Thanabalan - 26.07.2023 08:10

Sir, Thank you so much. It helps me a lot to understand the function very well.

Ответить
Mark Wafula
Mark Wafula - 22.07.2023 11:27

Easy to understand,

Ответить
Kyle
Kyle - 28.06.2023 00:47

WHY can't I find a single video of someone showing how to do "if this cell contains this text then insert another value in this cell?

Ответить
Lewd Twitch
Lewd Twitch - 22.06.2023 01:15

thanks

Ответить
Jane  Hillz
Jane Hillz - 20.06.2023 15:02

Thank you so much. You’re such a great 👍 teacher. God bless you

Ответить
Gabriel Kayode Oyedokun
Gabriel Kayode Oyedokun - 03.05.2023 11:24

thank you sir professor

Ответить
Drea Jam
Drea Jam - 27.01.2023 18:22

Thank you so much for creating these exercises. They are very helpful. I am literally on your channel every single day 😁

Ответить
Delaney Osborne
Delaney Osborne - 01.12.2022 02:18

mine is a yes or no instead or greater than less than

Ответить
Catrina Delima
Catrina Delima - 10.11.2022 22:27

Thank you for your knowledge. How can I create a formula for the following: IF data in cell A1 reads BAW-TCH-TIS, how do I have cell B1 equal cell A1, minus the first 4 letters or numbers? For example cell A1 reads BAW-TCH-TIS. Cell B2 should read TCH-TIS. I have 6,000 rows of data that I must remove the first 3 letters and the dash. Any assistnace would be greatly appreciated.

Ответить
Elizabeth Reyes
Elizabeth Reyes - 26.10.2022 20:10

New student here 😅

Ответить
Damir MT
Damir MT - 11.10.2022 17:40

thanks, can you show how to make colors change in cells depending on if statements

Ответить
irini viore
irini viore - 18.09.2022 20:56

Can we avoid the nested if by using the ifs?

Ответить
Isaac Boadi
Isaac Boadi - 17.08.2022 13:55

I'm really doing great will the excel tutorials. Simple and precise. Please help with the an if function for names. Example;
=IF(P10="Sir.Jamie","000001-great",IF(P10="Sir.Mike","000000-good",IF(P10="Sir.John","000015-normal",""))).
Thank you.

Ответить
leonardo Gathu
leonardo Gathu - 28.05.2022 17:39

If any sale in column C is $1200 same as cell f1 it displays Bad month.

Ответить
اکسل من
اکسل من - 24.04.2022 22:29

GOOD

Ответить
Ruel Jhon Alpay
Ruel Jhon Alpay - 16.03.2022 13:33

Thank you, sir, for posting another very useful lesson. Keep up the good work. Again, thank you so much.

Ответить
Meraj
Meraj - 11.02.2022 17:22

And why does this doesn't have more veiws

Ответить
Meraj
Meraj - 11.02.2022 17:21

Yoo it was very well explained. Iam now staring to get it a bit 😅

Ответить
Tafiqul Bari Rabbi
Tafiqul Bari Rabbi - 19.01.2022 00:11

Shout-out to Jamie Sir. An incredible teacher for us who walked through us so easily through the lessons of Count IF, Count IFS, Sum IF, Sum IFS, and IF function and many more lessons sir. I really like your teaching and the way you speak it seems you're explaining me right in front of me . Thanks again Sir.

Love from Muscat, Oman 🇴🇲

Ответить
rauf nasery
rauf nasery - 24.12.2021 10:16

i could not find they key to add dollar sign to add on both side of the cell id. i pressed f4, shift+4 and many more but could not. can you please help me find if you know?

Ответить
Góc Excel
Góc Excel - 19.12.2021 21:49

Hello

Ответить
Shwan Ibrahim
Shwan Ibrahim - 06.12.2021 20:22

thank you teacher for another useful lesson

Ответить
Evin Harrelson
Evin Harrelson - 30.11.2021 18:38

You are such a great teacher. I’m so glad you have these available for free here. If I were you, I’d be making money somehow off teaching others. You probably already are. Just saying. You’re good enough!!!

Ответить
Scott Gitlin
Scott Gitlin - 30.11.2021 00:25

YOU . . . are an excellent instructor.

Ответить
Lixin Zhang
Lixin Zhang - 27.11.2021 20:07

Can I ask why my laptop (HP), F4 doesn't come with $ (absolute value)? Thank you,

Ответить
Leslie Alvarez
Leslie Alvarez - 15.10.2021 05:31

You are an excellent teacher! Thank you for developing some of your time on teaching online!

Ответить
Avien Tzu-Er Wang
Avien Tzu-Er Wang - 13.10.2021 06:57

Great video as always!

Ответить
Mohamad
Mohamad - 11.10.2021 17:29

Why didn't you use the quantity column for explaining two if conditions?

Ответить
Technology Today
Technology Today - 10.10.2021 18:25

Hi

Ответить
brent T
brent T - 10.10.2021 18:17

Thank you, sir, for posting another very useful lesson this time. Keep up the good work.

Ответить
Victor Kipngetich
Victor Kipngetich - 10.10.2021 16:11

You screen is not visible try to enlarge

Ответить
Rick Palechuk
Rick Palechuk - 10.10.2021 15:43

Another great tutorial as always Jamie!
Thanks for sharing,
Cheers

Ответить
Brian King
Brian King - 10.10.2021 13:59

Thanks Jamie, excellent demonstration of the IF function. More like this please.

Ответить
suhayb AhMeD
suhayb AhMeD - 10.10.2021 12:33

Thanks 😊🙏alot 😘

Ответить
uptown3636
uptown3636 - 10.10.2021 12:23

🌟 😻 Meow 😻 🌟

Ответить
uptown3636
uptown3636 - 10.10.2021 12:22

👽¡Greetings from Mars!👽

Ответить
Animator
Animator - 10.10.2021 12:01

thanks this helped alot

Ответить