Master the IF Formula in Excel (Beginner to Pro)

I love it and I love you so much 😍

Good day Kenji, may I ask. How do I remove commas from a value in excel. For example, in a cell is R12, 234,984,00 my goal is to get R12 234 984,00

❤❤❤ it’s a wow. Thanks for this short presentation

Tutorial for Inventory Management system in excel pls

Hi,
Pls share excel file also for Practise.

Thank you! It's the " " explanation! I finally nailed my formula ❤❤❤

Do you think I have a reasonable understanding of the "IF" function?
This is a dynamic representation of calculating a tax liability, based on a variable taxable income and a tax table.

=IF(D13>C51;(D13-C51)*E52+D52;IF(D13>C50;(D13-C50)*E51+D51;IF(D13>C49;(D13-C49)*E50+D50;IF(D13>C48;(D13-C48)*E49+D49;IF(D13>C47;(D13-D47)*E48+D48;IF(D13>C46;(D13-C46)*E47+D47;D13*E46))))))

Hi, your video is great, I have a question, I want to create a formula that will only allow values from 600 to 1200 and do not allow other values to be entered. can you help?

Wow this is great thank you ..

You so kind in your teaching method, making it so easy to learn. God bless you richly.

Love your videos

Thank you so much , English is not my first language, but you explain very good and speak clearly ,🤗 I’m happy that I found you !

Excellent presentation, your grasp of the subject is quite impressive, but how you explain all the concepts is even more impressive IMHO.

Interesting video, thanks for sharing

I have no clue about excel😩❤️

Excellent, simple so simple but perfect.👍👍👍👍👍

I’m looking to change the value of a cell on an anniversary date. I’m calculating longevity payments that increase $100 on an employees anniversary date but starts on their 5th year. Can it be done? Can you help? Thanks in advance

Thank you for sharing your knowledge to us. Highly appreciated 💙

Can you write the formula for IFS function as shown in this video for me to look at it closely and apply.

Can we put a string of IF function in a Cell? Examples: IF less than 1000 = 10marks, IF greater than 1000 AND less than 2000 = 20Marks, IF greater than 2000 = 30 Marks?

Best presentation, I am learning some new concepts

You make learning fun. Keep up the good work and thank you Kenji.

Thank you so much for this. I am going to share this with my whole class.

Amazing

Thanks for sharing the wildcard IF function. Please can you share an approach to clean the data and produce only the country name.

Z

Hi, Your video about sumifs is very much great. Can Sumifs be combined with Vlookup? If it could be done, Pls. provide an explanation for it.

Thank U. Regards

I have been using Microsoft Excel since 2017 but the way you teach IF, IFS, SumIFS functions is on next level

Totally agree. Without this function my job would be so much harder.

I like the ampersand wildcard tie 👍😎✊

Hi, may i know your excel version?

Great tutorial thanks!!

Nice content 👍

Bravo. Thanks

Simply amazing...Thank you!

One of my favorite channel. Thanks Kenji

Making it very simple to understand. Thank you

Whats your opinion about ai and ongoing fear of replacing most of „corpo” jobs in near future? Would it be still worthy to get into finance career?

I used the shortcuts and functions in my job related exam, I passed it at got my job too❤ Tysm Kenji...

Hey Kenji! The wildcard saved me tons of time. Thanks so much!!!

Great 🎉

Thank you bro

Nice and neat explanation ..... as always. Kudos

Nice content! I didn't know the last trick, pretty interesting!!😲

Kenji the goat let’s goooooo

I really wanted to thank you for your great effort❤❤I learned alot from your videos keep it up✌🏽✌🏽

Thank you

Best Excel tutorials out there👌🏻