Hi There! Hi All, I love exploring MS Excel functions and formulas. The objective of this channel is to help people by making their work on excel easy and efficient. I offer tutorials on MS Excel (Basic to Advance) 💻👍👨💻 Cheers!!
Because I want to change my current Average i.e 67.5 to 70(Average I want ), so how much I need to score in the 5th subject. Hope that clarifies!! All the best for your exam. Thanks
Hi! Currently, the function renames files from similar folder, but there is a way we can use this function to rename files in multiple folders as well!! Will post a video soon on that. Thanks!!
Hi Ashfaq!, Thanks for your question. you have to Download the demo version of excel Add-in from the below location. Once you download and install it you will have access to all these functions. Let me know if you have any queries. shorturl.at/ijsQW
اسلام علیکم سر، سر ہم نے اگر کوئی ویلیو کو غلط پٹ کیا ہو، جیسے 0،1،2،3 لیکن بعد میں اسکو تبدیل کرنا ہو کہ 0 کی جگہ 1 ہوجائے، 1 کی جگہ 2 ہوجائے، 2 کی جگہ 3 اور 3 کی جگہ 4 ہوجائے تو یہ ہم کیسے کرینگے؟ اس کے لئے کوئی فارمولا ہے؟
Kindly make a short video on this and please reply me i will be thankful to you for this kindness Your business has a profit of Rs 26,000. You have set a new profit goal of Rs. 60,000. Currently you are selling 1400 items at Rs 25 each. If you still sell the same number of items, calculate by how much you should raise your price to achieve your target. Find the solution using Goat Seek.
I have created your solution, Check this out. You need to enter Cost of per item and in Profit you have to apply a formula i.e(SP*Qty)-(CP*Qty) i.e 25K. The amount you will get is 49.25(approx) drive.google.com/file/d/1l0NXQ3RWFTCh7m6WCPNRhcT9bwy9b2VW/view?usp=sharing
Hi, If i want to be knocked off the line items on the basis of currency value within each business area for ex.. debit 1000 & credit -1000 ... Then how to do that and which formula should I use?
It works only on similar debits and credits. However, you can round off all your numbers to 0 places of decimals and then apply this formula to make this work.
hello sir, In addition to above, there is any formula which setoff the also setoff the non equal no. Example suppose in your video u 102 setoff with -102 but if in line I want to setoff 102 with -95, -5 & -2 is there is any formula.