Eventhough I watched this video already but it is helping me for my real time working with my current requirement. So I watch your posted videos daily yo upgrade my knowledge.
Sir, U using if & and formulae for solution. Can we able to get solution by Nested if without using and formulae. Pls send your as "yes" or "No". After that kindly explain sir..
Bro... A column la 12345 nu oru id entry pandre... B column la 30.07.2018 nu oru date mention agum... Next 2nd row la... Customer id - date differents ah three date display agum.... Enaku single date separate ah multi date separate ah kedaikanum.... Blanks ah eduthukama...
Eventhough I watched this video already but it is helping me for my real time working with my current requirement. So I watch your posted videos daily yo upgrade my knowledge.
Keep upgrading Brother.
Nice. Thank u sir
Appreciate your interest. Happy learning.
Tq Sir..
நன்றி
Sir,
U using if & and formulae for solution. Can we able to get solution by Nested if without using and formulae. Pls send your as "yes" or "No". After that kindly explain sir..
Yes, but using AND along with IF formula makes our work easy.
Thank you Sir, how to arrive condition if 5 to 10 sales then Rs: 300, if it is more than 10 Rs700. thereafter for every 5 Rs.400. Maximum: Rs.50000.
It is easy sister, I will try to explain this in a short video.
Intha sister ketta question ku video iruntha share pannunga brother
Sorry, I forgot to address this question, will try to cover it quickly.
Ok brother
You have to use multiple conditions to solve this requirement. Say hi to prabas@prabastech.com, i will try to share the output with you.
Hi, Bro Averageif and Averageifs pathi detaila videos poduga bro.
Sure brother கட்டாயமாக ஒரு வீடியோ போடுகிறேன். நன்றி...
@@Prabasmsoffice thk you I,m waiting bro
Very much essential formula, thanks. Let me work out and if necessary I will let you know
Thanks for the comment. Keep upgrading.
=2.5 wrong >2.5 is correct.
Nice Video Sir..
Kindly upload practice file in your website prabastech.in
Thanks in Advance.
I will check and update it soon.
How I can sent query let me know please
1. UA-cam Comments
2. Email to prabas@prabastech.com
3. WhatsApp to 9940261814
Bro... A column la 12345 nu oru id entry pandre... B column la 30.07.2018 nu oru date mention agum... Next 2nd row la... Customer id - date differents ah three date display agum.... Enaku single date separate ah multi date separate ah kedaikanum.... Blanks ah eduthukama...
Bro i want to know about payroll class
Sir, ( choose & or ) vachi if condition la formula use pananum sir .
Hi bro I am working in abroad, one person is working in 9 hours working, athukum mela work pna athu OT so how to preparing the formula
Yes we can do that using SumIF
Itha video la avarukum 2.5 mela irutha MF varanum, but enaku. 9 hours mela ieutha athu thaniya Total venum
Pannalam, use SumIF