VLOOKUP with TRUE and IF Function [Calculate Commissions 💲]

Подписаться 385 тыс.

Просмотров 20 тыс.

50% 1

Step-by-step instructions for calculating commissions in Excel using the IF Function and VLookup formula.
Check out our 21 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
🔗 Download Practice files - bit.ly/3pLUpA2
✅ Learn Vlookup Formula in Excel - • Excel VLookup Formula ...
✅ IF Function for Beginners - • IF function Excel | Ne...
VLOOKUP with TRUE and IF Function [Calculate Commissions]
#vlookuptrue #excelformulas #calculatecommissions
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

Опубликовано:

7 мар 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@pradeepjangid490 2 года назад

Beauty of excel can be explained by Superstar only.

@prabhatbhardwajofficial Год назад

Excel superstar teaching method very easy . Thank you 😊

@sudiptamishra07 2 года назад

Thanks Rishabh for the Crisp Video.

@sahiranwar7856 2 года назад

Outstanding sir iski jarurt thi

@kajalsingh2897 2 года назад

You are amazing Rishabh, Thankyou for making excel so easy

@donbosco7535 2 года назад

Excellent way explanation.... When ever u get update a video. It's some thing very usefull to my portfolio...

@explore_learn_earn 2 года назад

Thanks for this formula

@mamalik1088 2 года назад

Nice explain again

@jaychikhalkar2351 2 года назад

Aapke excel videos dekh meri excel work m esay to work ho gaya hai sir Thank you sir 🙏

@amrutmisal1653 2 года назад

Thank you so much❤

@user-ny5vn7vp8d Год назад

Thank you thank you so much sir 😊😌 I have completed your whole playlist of excel It is soooo sooo toooo Amazing 😍 U r great at teaching and knowledge Stay bless for whole life 🧬

@asimshahzad5696 2 года назад

Thank you so much

@battlefansshorts8941 2 года назад

I love ❤ excel superstar

@gauravinstaking 2 года назад

Bhut badhiya sir

@vimaldewangan9309 2 года назад

Very interesting

@atherbeg2177 2 года назад

Excellent video Sir

@Universalyogi1 2 года назад

U r awesome bro i have watched lot of vdos of yours

@nitishbhagat7759 2 года назад

Really love your content so simple to understand thanks bhaiya... I can say Aaj Jo kuch v Excel me aata h sb aapki wajah se thanks a lot

@sanjeevkhakre2990 2 года назад

great sir 1st time see such use of vlookup thank you🙏

@hamidkhanafridi9 2 года назад

Thank you for explaining in easy manner.

@jjempowerstudio6348 2 года назад

Valuable stuff

@vijayarjunwadkar 2 года назад

Cool Tip Rishabh! You truly are Excel Superstar! Love your videos! 😊👍

@pravinkumbhare1750 2 года назад

Very useful Sir... Thanx for sharing practice file..

@SanviPatil2019 2 года назад

Kya baat kya baat kya baat sir

@karthiktn4112 9 месяцев назад

Super Sir.. thanks

@kuldeep.3012 2 года назад

Great video sir ji

@muhammadnazar2978 2 года назад

Superb trick

@devangthakkar6847 2 года назад

superb sir.

@supriyakanungo9039 Год назад

Excellent

@umarofficial1274 Год назад

Great Sir😊

@chetnawadhwa4345 2 года назад

Very gd explanation

@TallyAccount 2 года назад

Useful

@ck2768 2 года назад

Rishabh Sir, Superb Video. Simply by watching your videos, I have learnt a lot in excel and my day-today office work is becoming easier.

@jaychikhalkar2351 2 года назад

Very useful sir

@hariomjaiswal5789 2 года назад

What an explanation Sir 🙏

@tippusabeel62 Год назад

Sir tech more logic formulas n how to use which formula n files.

@devk.singhraghuvanshi8207 2 года назад

Good ☺️

@Arfatshadani 2 года назад

Very useful

@ExcelSuperstar 2 года назад

Glad to hear that

@Arfatshadani 2 года назад

@@ExcelSuperstar Ap Ki 200+ videos ne mujhe Excel Superstar bana Diya Thank You Sir ❤️ Lot's of love From Uttar Pradesh

@sufiataranum6486 2 года назад

Sir ur every video is so interesting and informative I always wonder if ur video on these subjects are not available how things would have been difficult. Hats off to u Sir one question how we will go ahead if there are 3 table to select instead of two.

@DineshSardesai 2 года назад

useful

@ExcelSuperstar 2 года назад

Glad to hear that

@sstudio4922 2 года назад

1st comment Sir...😍

@ExcelSuperstar 2 года назад

bahut khoob

@jaishree7125 2 года назад

Thanks for yet another useful video... My only fear with excel is I go blank whenever I get a data set in front of me and cannot figure out which formula to use and how ..I think this is also an art along with logical thinking and practice wherein you will be able to master in Excel. Can you please share few tips and tricks if any on how to decide or figure out which formula to use (How and When)

@ebcy1591 2 года назад

Plz make video with little more detailed manner as 5-10 minutes is required for understanding complete logic Syntex. Good keep it up. Thanks Kevyan.

@ExcelSuperstar 2 года назад

All the three topics have already been recorded and uploaded. Please check for VLOOKUP + TRUE, $ and SUMIFS. Repeating same thing in the video will make it longer and difficult to complete.

@sunilkumar-jl7uf 2 года назад

ग+ज+ब = गजब

@abidejaz1090 2 года назад

Bht umda Riship bhai kia aisa ho sakta hai k hum do column ka muwazna karte huey conditional formatting se aik column mai di hui range ko dosre column ki range k sath highlights karwa sake

@vishalbhati912 2 года назад

Muwazna ka matlab

@abidejaz1090 2 года назад

@@vishalbhati912 compare

@vishalbhati912 2 года назад

@@abidejaz1090 dono column ko select karo fir conditional formatting me jake highlight duplicate value kar do. Dono me jo same he unpe color ho jayega

@ExcelSuperstar 2 года назад

Try using formula based conditional formatting. Here is our English video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hFm_-rHMYV0.html

@abidejaz1090 2 года назад

Thanks let me check

@arbazrais 2 года назад

But how can I get formula from the cell instead of value. Can you please make a video?

@rahulgusain2048 2 года назад

Agar sale retrun hoga toh minus kese hoga

@mohamedsuhail3365 2 года назад

How to solve errors in this formula

@canirmalchoudhary8173 2 года назад

You removed the potential error by naming range

@mdshahidansari4892 Год назад

Sir how to connect with you

@aravrathor5595 2 года назад

Different from other

@vimaldewangan9309 23 часа назад

Dear Sir, Mujhe niche data ke according formulation ki jarurat hai kripya meri help kare. Mera Question Yeh hai 1st - Product name 2nd - Use type (yaha pe do condition hai chemical & black box gar chemical select kare to chemicals me consumption hona chahiye aur black box select kare to black box consum hona chahiye) 3rd - BOM Name (hamare yaha formula change hote rahta hai ek hi month me ho sakta hai do formula ho jaye isme mere master data me formula ka name dede to bom name me formula name ke hisab se data multiply ho jaye.) 4rd - No.of batches 5th - batch size 6th - Qty (inke sath multipaly hona chahiye) Please help sirji