Rath Point

190
1 627 723

Rath Point's Official RU-vid Channel.

In Rath Point, watch MS Office Tutorial videos. SUBSCRIBE Rath Point, Like, Share and click on bell icon to get notifications for new videos to improve your MS Office skills.

We are updating the MS Office tutorial videos from time to time with more valuable contents, to improve your knowledge.

Please feel free to COMMENT on videos which will motivate us to add more videos for you.

MS Office is so much important now a days and you must learn it.

Thanks for watching in Rath Point RU-vid channel.
Have a Great Day and Stay Safe.
#RathPoint

Комментарии

@abrahamelnash 8 часов назад

Thanks it worked for me

@rathpoint 7 часов назад

Welcome 😊

@Transitbites День назад

thanks

@rathpoint День назад

Welcome 😊

@--__--. 4 дня назад

Thank you so much sir Subscribed ❤ I was looking for shortcuts which actually works . Thank you once again sir❤

@rathpoint 4 дня назад

You're welcome 😊

@jimvashro2872 8 дней назад

Hi, your video helped. When I did the search for 'keyboard' it didn't bring up the onscreen keyboard... I then typed in 'onscreen' and the search bar brought up onscreen keyboard and I was able to click off the scroll lock! Thanks

@rathpoint 8 дней назад

I am glad that it helped you. Thanks for your comment ☺️

@nehamaity7118 10 дней назад

If we share it in whatsapp group, than can the people in the group change it or edit it from mobile

@rathpoint 10 дней назад

Excel mobile version is always with limited features. Full features are available only in Windows or Mac version.

@ParthiUsha 10 дней назад

thanks boss, useful information.

@rathpoint 10 дней назад

Welcome 😊

@AjPlayGames 11 дней назад

To be honest, this is not really useful. I put formatting, formula and other for a purpose. Removing it will not help. You should speak about other options such as Power Query or alternatives.

@rathpoint 11 дней назад

Let me know the issue clearly, so that I can provide the solution.

@TheDunbelievable 12 дней назад

MY MAN !! nice =CHOOSE(LEFT(TEXT(A1,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--LEFT(TEXT(A1,"000000000.00"))=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),2,1)=0,--MID(TEXT(A1,"000000000.00"),3,1)=0)," Hundred"," Hundred and ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A1,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"), CHOOSE(MID(TEXT(A1,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &IF((--LEFT(TEXT(A1,"000000000.00"))+MID(TEXT(A1,"000000000.00"),2,1)+MID(TEXT(A1,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(A1,"000000000.00"),4,1)+MID(TEXT(A1,"000000000.00"),5,1)+MID(TEXT(A1,"000000000.00"),6,1)+MID(TEXT(A1,"000000000.00"),7,1))=0,(--MID(TEXT(A1,"000000000.00"),8,1)+RIGHT(TEXT(A1,"000000000.00")))>0)," Million and "," Million ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A1,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),5,1)=0,--MID(TEXT(A1,"000000000.00"),6,1)=0)," Hundred"," Hundred and")) &CHOOSE(MID(TEXT(A1,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") &IF(--MID(TEXT(A1,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(A1,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen")) &IF((--MID(TEXT(A1,"000000000.00"),4,1)+MID(TEXT(A1,"000000000.00"),5,1)+MID(TEXT(A1,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(A1,"000000000.00"),7,1)+MID(TEXT(A1,"000000000.00"),8,1)+MID(TEXT(A1,"000000000.00"),9,1))=0,--MID(TEXT(A1,"000000000.00"),7,1)<>0)," Thousand "," Thousand and ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A1,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),8,1)=0,--MID(TEXT(A1,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))& CHOOSE(MID(TEXT(A1,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A1,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(A1,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))

@rabiyasultana3304 13 дней назад

Thank u so much

@rathpoint 13 дней назад

Welcome 😊

@RiazUllah-w2p 14 дней назад

Pls share formula to highlight cells having small alphabets/ letters

@rathpoint 14 дней назад

First, use the formula mentioned in this video to count lowercase. Then use conditional formatting with IF >0 and give color to highlight. Hope you got it.

@RiazUllah-w2p 13 дней назад

@@rathpointsir, I want to highlight small letters in the whole sheet, not in a single column? Is this possible

@rathpoint 13 дней назад

Yes, include formula in conditional formatting.

@satishloyare4583 14 дней назад

Thnx bru

@rathpoint 14 дней назад

Welcome 😊

@thekainatworld6530 16 дней назад

U solve my problem.i search 2.5 hour continuously RU-vid videos

@rathpoint 16 дней назад

I am glad that it helped you. Thanks for your comment.

@gokulrag8444 18 дней назад

Good infm❤

@rathpoint 18 дней назад

Thanks 😊

@mochadoe4211 22 дня назад

Help

@rathpoint 22 дня назад

Hope it helped you.

@mochadoe4211 22 дня назад

I tried the formula but it still give an error.

@mochadoe4211 22 дня назад

Please help

@rathpoint 22 дня назад

Let me know your formula.

@mochadoe4211 22 дня назад

Did you get the video clip?

@mayank3499 24 дня назад

thanks bro

@rathpoint 23 дня назад

Welcome

@hd.shorts_09 25 дней назад

Thank you so much ❤

@rathpoint 23 дня назад

Welcome 😊

@sharukhmirkar5836 26 дней назад

Thank You so much bro❤

@rathpoint 25 дней назад

Welcome 🙏

@akashdas9897 27 дней назад

Thank you 🙏

@rathpoint 27 дней назад

Welcome 🙏

@c-e-mhealth2728 Месяц назад

Thank you....... Useful

@rathpoint 29 дней назад

Welcome 😊

@richardbird2873 Месяц назад

Excellent, thank you.

@rathpoint 29 дней назад

Welcome.

@krisnaindo Месяц назад

You really help a lot, thank you so much👍

@rathpoint Месяц назад

Welcome 😊

@harish7041 Месяц назад

Can we use if function instead minus please show me how to do it ,and show how to compare number and text combination to get if function For example if coloumn C4 contione 500 and D4 contains true word I should get valid text in E5

@rathpoint Месяц назад

Instead of multiple IF functions, use IFS function. Check the short video: ru-vid.comHuweiCz97kg?feature=share

@olakos1892 Месяц назад

Very helpful! Thank you

@rathpoint Месяц назад

Welcome 😊

@varun5525 Месяц назад

😊 thanks

@rathpoint Месяц назад

Welcome 😊

@user-du7su4vj5v Месяц назад

Thank you very much, this help me much, love u

@rathpoint Месяц назад

Welcome 😊

@Sairampaduri Месяц назад

Super

@rathpoint Месяц назад

Thanks 😊

@kutlwanokewagamang5231 Месяц назад

Thank you so much for this.

@rathpoint Месяц назад

Welcome 😊

@roopeshnaroth8069 Месяц назад

🙏

@rathpoint Месяц назад

🙏

@christopherlins1579 Месяц назад

Thanks

@rathpoint Месяц назад

Welcome 😊

@user-nq1sx3dq8n Месяц назад

Thank you so much meri problem solved ho gai bhai😊

@rathpoint Месяц назад

I am glad that it solved your problem. Thanks for your comment ☺️

@CameronClark-i5m Месяц назад

wow thank u so much

@rathpoint Месяц назад

Welcome 😊

@dariodias3884 Месяц назад

If I use number 852000 it shows as eight hundred fifty two thousand instead of eight laks fifty two thousand

@rathpoint Месяц назад

You can replace the text lakhs with thousand.

@ShamsherSingh-ps2hl Месяц назад

thanks, yes it works

@rathpoint Месяц назад

You're welcome!

@sudeepsudeep9590 Месяц назад

Tq sir❤

@rathpoint Месяц назад

Welcome 😊

@lassie6199 Месяц назад

the music is nice but please keep in the intro only its distracting me from listening to your voice, or at lease make it more quiet when you are talking just a suggestion thanks :)

@rathpoint Месяц назад

Sure will do. Thanks for your suggestion 😊