Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++, C#, JavaScript, Python, Microsoft Office, AutoCAD, Adobe Illustrator, Data Entry, and Web Scraping.
Rating scales are used to evaluate responders' feedback towards a particular product. Excel can help greatly in creating a rating scale for any number of ...
If you need to keep track of mortgage loan status, Excel can help you greatly. In Excel, you can easily create a table of the various stages and regularly ...
Sometimes we work with a large amount of data in Excel. Keeping track of this much data is often very difficult. In this article, we will show you how to ...
Residential construction estimator is a method of evaluating the potential cost of construction by calculating material quantities and their costs with the ...
One might need to put a line over text for various purposes. For instance, Means and Vectors are expressed by putting a bar on the top of a text in ...
Symmetric datasets give us normal distribution curves, whereas asymmetric datasets give us skewed normal curves with different shapes of peaks. Asymmetric ...
While working with a large amount of data, one might need to filter only a fraction of the whole data for various purposes. Excel can be a very useful tool for ...
Sometimes you might want to know information before clicking on anything in Excel. You can do it by adding a tooltip to a text, shape, and image that will be ...
Sometimes you might need to enclose a text inside a circle to highlight it or for some other purpose while working on Excel. You can do this easily and quickly ...
ComboBoxes and listboxes are useful approaches to controlling the consumer experience by confining the values that a consumer can choose to a predefined list. ...
Sometimes we need to write a large text of multiple lines in Excel. Text boxes are very useful when it is necessary to show a large text in Excel. Moreover, ...
Sometimes we need to find combinations of various things. Only a few different things can have a large number of combinations. As a result, finding these ...
Checklists are essential for an individual to keep track of tasks already completed and tasks that need to be done yet. Excel can help in creating a checklist ...
Using keyboards while working in Excel can increase efficiency and speed. It often saves time and reduces boredom. Changing the font size every time using a ...
An individual might need to print some Excel data on a piece of paper. To do that, Excel worksheets need to be properly aligned to the printing page to get the ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
Hello FAIS,
Follow these steps to get your desired result.
=LN(C6/C4)/LN(1+C5)
In the formula, C6 refers to the desired salary (75000000), C4 refers to the current salary (307584) and C5 refers to the increment percentage (10%).
=INT(C8)&" years " & INT(MOD(C8*12,12))&" months"
Here, C8 refers to the required time in years.
Hello Tom,
The upward arrow between C9 and C10 in the formula indicates the exponent operation of mathematics. In the formula, C9 raised to the power of C10 is written as C9^C10. A simple example would be “Two Squared” which is written as 2^2 = 4, where 2 is raised to the power of 2, resulting in 4.
Hello Claire,
Follow these steps to make the stacked bar charts of Likert scales.
Insert >> Charts >> 100% Stacked Column
Hello Torsten,
Thank you for bringing this matter to our attention. We will look into the VBA function to see if it can be updated to minimize the deviation of the orange line from the given points.
Besides, I would like to address your concern regarding interpolation methods. There are some interpolation methods that go through all the given points such as Lagrange interpolation or polynomial interpolation etc. However, interpolation method such as cubic spline interpolation does not necessarily pass through all the given data points.
Hello SANJAY DANGI,
Thank you for reaching out. You can add attachment to the email in the first method easily. Follow these steps to do it.
Sub ExcelToOutlookSR() Dim mApp As Object Dim mMail As Object Dim SendToMail As String Dim MailSubject As String Dim MailBody As String Dim FileName As String Dim Path As String 'Declare variable for file path Path = "D:\Exceldemy\" 'Set file path For Each r In Selection SendToMail = Range("C" & r.Row) MailSubject = Range("F" & r.Row) MailBody = Range("G" & r.Row) FileName = Range("H" & r.Row) 'Get file name from H column Set mApp = CreateObject("Outlook.Application") Set mMail = mApp.CreateItem(0) With mMail .To = SendToMail .Subject = MailSubject .Body = MailBody .Display .Attachments.Add (Path & FileName) 'Add attachment End With Next r Set mMail = Nothing Set mApp = Nothing End Sub
Hello Theo,
Follow these steps to adjust ranges to make a longer list without any error.
1. First, to make the task list longer, select cells H13 through J13. Then drag the fill handle down to add new task.
2. In this example, we added five new tasks. Therefore, the new ranges for column H, I and J are H6:H18, I6:I18 and J6:J18 respectively.
3. Then select cell D6 and change the ranges of H,I and J cells in the formula bar and press Enter. After that, Autofill formula up to cell D9.
4. Similarly, change the formula ranges for other cells as well.
5. Finally, you can see in the following figure that the formula is working properly.
I hope this solves your problem. Please let us know if you face any other issues.