Alif Bin Hussain

Hello FAIS,

Follow these steps to get your desired result.

• You can use the following formula to calculate the time required to get the desired salary. This formula will give you the result in years only.

=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%).

• If you want the results to be in years and months, use the formula given below.

=INT(C8)&" years " & INT(MOD(C8*12,12))&" months"

Here, C8 refers to the required time in years.

• You can set up your Excel worksheet like the following image given below to get the desired result.

Hello Claire,

Follow these steps to make the stacked bar charts of Likert scales.

• First, select the range B4:G10.
• Then go to,

Insert >> Charts >> 100% Stacked Column

• As a result, the chart will look like the following image.

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.

• In this example, we want to attach a file named Attachment.pdf. The path directory for the file is D:\Exceldemy\.

• First, download the workbook provided in this article and open it.
• Next, add a new column (H) and write the file names you want to attach to the email. Make sure to write the file extension.

• Then, open the code module and write the following code.

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

• After writing this code, go back to the excel sheet.
• Then, select one or more names and click on the button.

• As a result, Microsoft Outlook software will open and you will find the email already written with the attached file. You can just click send to send the Email.