apka sir jawab nahi, etna detail se ekdm bariki se samjhaya hai sir apne, ekdm crystal clear ho gya. sir ek req hai ek aisa formula pr video bataiye jo numeric value ko apne aap round off kre mtlb last me agar 5 se km ho to zero kr de or agar 5 se zayada to next digit ke kareeb round up kr de jaise agar 372 aye to 370 dikhaye or agar 377 aye to 380 kr de .i hope aap samjh gye hoge me kya chahta hu. pura youtube dekh liya kisi ni video ni bnaya hai or jihone banaya unka samjh ni aya. plz help me.
Sir Jo aapne last mai date mai text ka formula use Kiya h sir mujhe ush mai kuch puchna tha sir jaise hame date 01-01-2022 ye date de rakhi h ab mai chahta hu ki aap text ka formula use kr k jaise kishi Khali cell mai 01 ye likhe tua Jo maine 01-01-2022 date di h issh k according 01 likhte he issh k upar aaj kon sa war h ye aa jaye sir isshe solve kro
I think reply nahi kar sakthe hai becz unkho bhi nahi atha becz most of ye jo lectures Lethe hai na unkhe suvidha khe anusaar Lethe hai but hum nee aisa koi questions pucha na Answer nahi dhethe becz unkho nahi atha hai simple
Kya excel sheet m kisi ek alphabet se koi formula jo kisi line m likha usi line k formule ko me kisi dusri line me us tax ko click kr whi formula laga skta hu
How we will subtract the excess number from multiple required number and add remaining value in other cell in 1 formula. Eg we made 1 attendance sheet in excel using 8 hours per day, if in any cell showing more than 8 hrs would be consider overtime. So please explain me the formula if more than 8 hr showing (suppose it is showing 9, 11, 10, 10 in a month. I want to add excess number respectively 1, 3, 2, 2)
Dear well-done I watch and follow your excel videos. I am facing one problem, I want auto generate product code, like I put my formula in A1 and my product will be show in B1 Column Like before I am doing (If B1="" ,"",A1+1) but now i want with text like "pro0001" and next pro0002"
One simple problem. When we split data (text to column) like 5/3,Nirala nagar,9/6,Lucknow. I am getting that 5/3,9/6 are changes to date like 5 March, 9 Jun. Please give solution on text to column formula
Font colour kaise change kre & formula ke sath, yani agar sirf "date" text ka color change karna ho aur cell reference ka bhi koi alag color Dena ho to kaise kare
Hi ...i have some doubts on excels as i need to develop excel applications for down loading data from the web and also so for analysing data ..can you support me on excel related queries. I have if i subscribe ...
I want to write Profit declare is 12% of rs 1300000 12% bhi kisi column se select Krna hai And 1300000 sale ki value hai To kese set krenge sir... Please reply
I have a format which I can use many times, how can I do if I don't want to replicate that format? I have written the text format in one cell and then refer text function to this cell (eg I have written """increase ""###,###;""decrease ""###,###" in cell A5 and then write formuala Text (A1,A5)) but it doesn't work.
Hie sir mujhe ek hii column mai 2 serch criteria chaiye jese A2 mai ram likha hua h or A3 shyam hai then mujhe A4 mai kya likha hua hai ye search krna h
when im text formula in which month.. like 01-02-21 formula is =text(input cell,"mmm") but one problem every time show month name jan when cell is empty plz help me
hi, Professor , I have a question: If we have numbers in different formats, for example: liters, meters ... When we do research (we use search functions) in the cells that contain these numbers, can we get numbers with their different formats? Thank you so much.😃👍
Good morning, when we use the search functions in Excel, we do not get the cell formatting that we are looking for. I want to get the full cell format. Is that possible? I thank you for all the efforts you are making through these videos, thank you so much.😃👍
Good evening Professor, I thank you for the answers that you sent me on the Internet. May God protect you. Suppose we have in cell a1 = "excel", in cell a2 = "is", in cell a3 = "fun", in cell b1 = 12.00m, in cell b2 = 10.00gr, in cell b3 = 15.00kg, use the vlookup function: vlookup = ("is", $ a $ 1: $ b $ 3,2, false), the result is 10, which means that This function didn't give me the full format of the number in cell b2 (b2 = 10.00gr), but my goal is to get b2 = 10.00gr and not b2 = 10. thank you so much.😃👍
Thank you dipak sir, your teaching style is very good
Thanks for excel titorial
apka sir jawab nahi, etna detail se ekdm bariki se samjhaya hai sir apne, ekdm crystal clear ho gya. sir ek req hai ek aisa formula pr video bataiye jo numeric value ko apne aap round off kre mtlb last me agar 5 se km ho to zero kr de or agar 5 se zayada to next digit ke kareeb round up kr de jaise agar 372 aye to 370 dikhaye or agar 377 aye to 380 kr de .i hope aap samjh gye hoge me kya chahta hu. pura youtube dekh liya kisi ni video ni bnaya hai or jihone banaya unka samjh ni aya. plz help me.
Thanks Dr.deepak excel, mera kam ho gaya, main Jo question pucha tha uska javab mil gaya, thanks sir
Nice tutorial
Nice sir ji 👌👌👌
Thank you sir!!
Your way of teaching is good. Learned a lot
बहुत खूब
Sir jii aapki sabhi video itni achhi hoti hain
Ki kbhi kbhi mein sochta hoon ki aapki taarif ke liye word kaha se laau
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
😊😊😊😊😊♥️
Very nice
You are great
Thank you, Sir ji 🇧🇩
Thank you so much sir ji for this video 🙏
Very nice video Sir, Thank you Soo much
Very good formula deepak
Thanks sir jee... Your great God gifted as teacher.....thanks.. Shabir.Dubai
👍👍
Great work sir
Thanks.
Mind-blowing 🇮🇳
👌👌👌👌
Very nice explain text formula in different example is very simply styles thank you sir
Good Work Deepak 👍🏻 Keep it up
Great
Thanks 👍👍👍👍👍👍👍👍
V.good explained
Thanks
Sir Jo aapne last mai date mai text ka formula use Kiya h sir mujhe ush mai kuch puchna tha sir jaise hame date 01-01-2022 ye date de rakhi h ab mai chahta hu ki aap text ka formula use kr k jaise kishi Khali cell mai 01 ye likhe tua Jo maine 01-01-2022 date di h issh k according 01 likhte he issh k upar aaj kon sa war h ye aa jaye sir isshe solve kro
I think reply nahi kar sakthe hai becz unkho bhi nahi atha becz most of ye jo lectures Lethe hai na unkhe suvidha khe anusaar Lethe hai but hum nee aisa koi questions pucha na Answer nahi dhethe becz unkho nahi atha hai simple
Very very new on you tube excel
Thanks for your kind information.
Good night sir,
Great👍 teacher
Bahut badiya
Thanks very much Sir ji
Badiya bhai
Great Sir👌👌
Sir, Perfect.
Nice one sir 👍
Nyc video sir
Love and respect you sir
Best used ... Thanks
Thank You 👌
Sir power query usage with real time examples video share karo
very useful video sir
Good sir
good
very good tutorial thanks for sharing
Nice sir
Sir please excel file bhi share kardiya karen practice mai help ho jati hai 💐 from 🇵🇰
Very nice sir
Nice work..
sir me ne ap k takreeban sari videos dekhee hai...kia ap school management system pr video bana sakty hai?
Super trick
Fantastic 👍👍
Please make video on custom no format in detail
Owsm
I have subscribed your channel but never get notification for new video
Sir ms word basic to advance video upload kare
Nice Sir ji
Very useful
👍
Well done
awsome sir...
Nice
Thanks sir
Excellant
Excellent
👍👍
How to bold or Underline text with & Sign (Due to joint text)
Kindly upload vedio how to use text tab delimited function in excel 2016.
Thank you ❤️
Hi sir ham excel me text per Kam karte hen ya formula per
Flash fill is easy method sir
Kya excel sheet m kisi ek alphabet se koi formula jo kisi line m likha usi line k formule ko me kisi dusri line me us tax ko click kr whi formula laga skta hu
Like the way. Brother says aaxle me na
Sheet last modified date kase dekhe formula se plz video baniye
How we will subtract the excess number from multiple required number and add remaining value in other cell in 1 formula. Eg we made 1 attendance sheet in excel using 8 hours per day, if in any cell showing more than 8 hrs would be consider overtime. So please explain me the formula if more than 8 hr showing (suppose it is showing 9, 11, 10, 10 in a month. I want to add excess number respectively 1, 3, 2, 2)
Dear well-done I watch and follow your excel videos.
I am facing one problem, I want auto generate product code, like I put my formula in A1 and my product will be show in B1 Column
Like before I am doing (If B1="" ,"",A1+1) but now i want with text like "pro0001" and next pro0002"
Masterpiece
Sir office 2019 me F2 Se cell edit nahi ho raha hai iske liye kya kar sakte hai ?
Aap excel options ke advanced option me jaakar allow editing directly in cell wale option ko check krke ok kijiye Or phir try kijiye ho jaayega 👍👍👍
@@vimalsoni185 ok thank you so much.👍👍👍👍👍👍🙏🙏🙏🙏
@@vimalsoni185 👌👌
Sir apki qualifications ky h
Apne computer me koun sa course kiya h
How to check out remarks value from 2 sheet
One simple problem.
When we split data (text to column) like 5/3,Nirala nagar,9/6,Lucknow. I am getting that 5/3,9/6 are changes to date like 5 March, 9 Jun.
Please give solution on text to column formula
I ll include this query in next excel tips video 🙂🤗👍
Font colour kaise change kre & formula ke sath, yani agar sirf "date" text ka color change karna ho aur cell reference ka bhi koi alag color Dena ho to kaise kare
Sir ye new version mein kaam karta hai kya
Available in All versions
Hi ...i have some doubts on excels as i need to develop excel applications for down loading data from the web and also so for analysing data ..can you support me on excel related queries. I have if i subscribe ...
I want to write
Profit declare is 12% of rs 1300000
12% bhi kisi column se select Krna hai
And 1300000 sale ki value hai
To kese set krenge sir...
Please reply
Sir how to convert the digits to in words
I want to concetenate decimal number with text upto 2 decimal point in excel .
How can I
"#.00"
I have a format which I can use many times, how can I do if I don't want to replicate that format? I have written the text format in one cell and then refer text function to this cell (eg I have written """increase ""###,###;""decrease ""###,###" in cell A5 and then write formuala Text (A1,A5)) but it doesn't work.
Sir mujhe Data entry ki course kr na TH-cam pe koi achi link send kro
Advance excel ka notes hai to send me please sir
How to colum A1, 01 Bottle and 02 Bottle Come written yah condition formatting and format cell In excel please help me
Use of hash?
Training file for this video is not available in description. Plz provide sir.
Hello sir agar excel me ek hi cell me text>mukesh>text likha h to mukesh ko alag cell me kaise kare .
दीपक जी कही पर सम माइनस में आता है तो स्पेल नंबर का फार्मूला कम करना बंद हो जाता है कृपया गाइड करे
Sir vo automatic attendance sheet muje bhejiye na sir please
Hie sir mujhe ek hii column mai 2 serch criteria chaiye jese A2 mai ram likha hua h or A3 shyam hai then mujhe A4 mai kya likha hua hai ye search krna h
when im text formula in which month..
like 01-02-21 formula is =text(input cell,"mmm")
but one problem every time show month name jan
when cell is empty plz help me
How can a number like 1234987650 can be written in text spelling in excel using simple formula
Sir text ka kya use hai
Why do we use & before use formula
1 ते 100 अंक तारीख के सात बदलना चाहिये (उदा.१/२/२०२१ तो 1 अंक और १/२/२०२१ या तो 2अंक आना चाहिए कोन सा फॉर्म ला यूज़ करे
Isi Text formula se hoga... Series se dates likho... Or text formula lagao.. format me "d" likho bas 👍
सर आप इस पे एक वीडियो तयार करे विनंती
@@aminpinjari4070
COLUMN H FORMULA RESULT
18 01-02-2021 =TEXT(H18,"d") 1
19 02-02-2021 =TEXT(H19,"d") 2
Where is training file?
hi, Professor , I have a question: If we have numbers in different formats, for example: liters, meters ... When we do research (we use search functions) in the cells that contain these numbers, can we get numbers with their different formats? Thank you so much.😃👍
Good morning, when we use the search functions in Excel, we do not get the
cell formatting that we are looking for.
I want to get the full cell format. Is that possible? I thank you for all the efforts you are making through these videos,
thank you so much.😃👍
Good evening Professor, I thank you for the answers that you sent me on the Internet. May God protect you. Suppose we have in cell a1 = "excel", in cell a2 = "is", in cell a3 = "fun", in cell b1 = 12.00m, in cell b2 = 10.00gr, in cell b3 = 15.00kg, use the vlookup function: vlookup = ("is", $ a $ 1: $ b $ 3,2, false), the result is 10, which means that This function didn't give me the full format of the number in cell b2 (b2 = 10.00gr), but my goal is to get b2 = 10.00gr and not b2 = 10. thank you so much.😃👍