This video might suites for people do projection plan such insurance agent, property agent and financial advisor. I had a doubt sir. If the parameter for % does not contains in sheet, can we still use the data validation for calculation?
Yes.i understood bro... previous two option that you posted us that goal seek and scenario manager its really useful for my real time working. And this is one more option to know projection plan. I want to share this your explanation is very clear....thanks for posting bro.... keep posting.... and I am waiting for your next two more examples in upcoming video....
Hi bro I have a question about countif For example In staff attendance sheet Leave (L) and half-day (HL) So then how to count L+HL= 1.5 day leave And conditional formatting text colour How can apply L and HL I need different colours But I'm trying not works because There is L and HL can't apply different colours..pls bro make it tutorial for me Thank you
I would like to hear your feedback personally, could you please share your contact number to prabas.msoffice@gmail.com. it is not necessary, you can also ignore this request if you are not interested. Do not share your contact number here, email please.
This video might suites for people do projection plan such insurance agent, property agent and financial advisor.
I had a doubt sir. If the parameter for % does not contains in sheet, can we still use the data validation for calculation?
That's correct
Super vera level smoothly teaching🎉🎉🎉🎉🎉🎉
Thanks for your time in watching and reviewing this tutorial. Please explore our other videos too.
Super learning Video ji
Excellent 😊👌👍😊
Super ji
Super explain sir
sir super teaching
Thankyou sir 🙏🙏
Yes brother TKS you way of explanation super.
I understood 🙂
In 6:41
Great Information
Output cells always contains Formula
Super
Unga voice super sir
Please watch all the videos from playlist
K BRO sure
Eagerly waiting for 2nd part sir..
Excellent
Hope you watched the entire tutorial.
Yes.i understood bro... previous two option that you posted us that goal seek and scenario manager its really useful for my real time working. And this is one more option to know projection plan. I want to share this your explanation is very clear....thanks for posting bro.... keep posting.... and I am waiting for your next two more examples in upcoming video....
Thanks for watching this entire tutorial
Little confusing, but I'm waiting for next part
Yes sir thank you
In 10:42
Really Helpful
We will create and send
Can you update it on your community tab or your blog
Sure Karthick, noted. With thanks.
Hi bro
I have a question about countif
For example
In staff attendance sheet
Leave (L) and half-day (HL)
So then how to count L+HL= 1.5 day leave
And conditional formatting text colour
How can apply L and HL I need different colours
But I'm trying not works because
There is L and HL can't apply different colours..pls bro make it tutorial for me
Thank you
= Countif (range1, criteria) + ( countif (range2, criteria) * 0.5)
@@Prabasmsoffice thanks a lots brother
I'll check this
Bro may I kw to formula to get returns
sir, one doubt
how to edit data table?
Anna..enkita oru excel worksheet iruku ...athula data tab tha use panirukanga..ana epdi answer potrukanganu enaku therila..konjam help pana mudiyuma
Sure, share the file to prabas@prabastech.com
@@Prabasmsoffice sir anupiruken..konjam pathutu solunga
Return value money enna formula use panrathu
Kindly explain your question again?
Enaku oru doubt return varuthula athu five year evlo varum
Ithula enna formula use panna indratha sollave illiye
where part 2 date video sir
Appreciate your interest, you are one of the few asked this question. I will put the part 2 video soon.
tq sir I am waiting
@@Prabasmsoffice Your video is very interesting. I learnt a lot from your teaching. I couldnt found 2nd part of video. Can you share it please??
sir one doubt
What?
Sir I am practice data table.,
I get results in bar code
next step sir
What is your expected outcome?
full amount result
Formula
please tell me sir
I am sorry brother. Your voice disturbs.. speak normally..
I would like to hear your feedback personally, could you please share your contact number to prabas.msoffice@gmail.com. it is not necessary, you can also ignore this request if you are not interested.
Do not share your contact number here, email please.
Bro ungka number send pannungka
prabas.msoffice@gmail.com
Thankyou sir 🙏🙏
Thank you sir