About author
## Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.
## Lives in

Dhaka, Bangladesh.
## Education

B.Sc. in Civil Engineering, BUET.
## Expertise

Microsoft office, AutoCAD, Adobe Illustrator, Data Entry
## Experience

Raiyan Zaman Adrey, armed with a BSc in Civil Engineering from Bangladesh University of Engineering and Technology, efficiently combines engineering skills with a passion for Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only tackles complex issues but also demonstrates an enthusiastic mindset, efficiently managing critical situations with patience, showcasing his commitment to excellence. He is interested in C, C++, C#, JavaScript, Python, Microsoft Office, AutoCAD, Adobe Illustrator, Data Entry, and Web Scraping.

- Technical Content Writing
- Undergraduate Thesis
- Quantifying High Resolution Intra-Urban Spatial Variability of Fine Particulate Matter Across Dhaka City

In this Excel tutorial, you will learn -The basics of Excel area and volume calculator. -The calculation of the area of various 2D geometric shapes. -The ...

Raiyan Zaman Adrey
Apr 29, 2024

A timeline is a representation of events in chronological order. Download Practice Workbook Timeline in Excel.xlsx How to Create a ...

Raiyan Zaman Adrey
Aug 4, 2024

Here's an overview of a box and whisker plot and a surface chart in Excel for stocks. Download the Practice Workbook Stock Chart in Excel.xlsx ...

Raiyan Zaman Adrey
May 16, 2024

In column charts, the values are typically aligned along the vertical axis and the categories are typically aligned along the horizontal axis. Column charts ...

Raiyan Zaman Adrey
Aug 6, 2024

We often need to organize data in Excel while working for easy data management, better data analysis, better visualization, and more efficiency. Here's an ...

Raiyan Zaman Adrey
Jul 4, 2024

Method 1 - Finding Missing Values Using a Combination of IF and COUNTIF Functions Steps: Select cell F5. Enter the formula below: ...

Raiyan Zaman Adrey
Jul 5, 2024

This is an overview. Download Practice Workbook Clipboard in Excel.xlsx What is the Clipboard in Excel? The Clipboard is a temporary ...

Raiyan Zaman Adrey
Aug 3, 2024

This is an overview. Download Practice Workbook Download the workbook here. Trendline for Part of Data.xlsx What is a Trendline in ...

Raiyan Zaman Adrey
Aug 2, 2024

In this article, we will demonstrate some of the most commonly used methods of calculating safety stock in Excel, from the simple arithmetic way to some ...

Raiyan Zaman Adrey
May 24, 2024

In this article, we will demonstrate how to utilize VBA to call a subroutine (sub) from another workbook, both opened and closed. We will also discuss related ...

Raiyan Zaman Adrey
Jul 7, 2024

Method 1 - Excel SUMIF Greater Than Specific Value Select cell D20, apply the formula below, and press Enter. =SUMIF(C5:C17,">2") ...

Raiyan Zaman Adrey
May 27, 2024

What Is Slicer? An Excel slicer is a visual filtering tool that enhances data filtering. It is used in conjunction with tables, pivot tables, or pivot ...

Raiyan Zaman Adrey
Jul 18, 2024

In this article, we will demonstrate the use of Excel VBA to perform text to columns operations on fixed-width data types using the TextToColumns method. The ...

Raiyan Zaman Adrey
Jun 13, 2024

The sales run rate is used to estimate a company's potential future revenue based on its present revenue. It is determined by dividing the total current sales ...

Raiyan Zaman Adrey
May 17, 2024

Browsing All Comments By: Raiyan Zaman Adrey

About ExcelDemy.com

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

Dear

Emely Phiri,Thanks for reaching out to us. Let’s clear your confusion.

Think of it this way, you already know how one can calculate annual interest when one has the principle and the every month’s saving’s amount. If it is simple interest, you use the

I=P*r*nformula and for compound interest, you useI=P*(1+r)^n-P.Now, if I say, your principle is

$1200, interest rate is10%then the annual interest using the simple formula would be$1200*0.1*1=$120right? Which means, the interest you are actually getting is$120/12=$10every month. And if you save like$50every month, the total amount in your account at the end of the first month and at the beginning of the second month will be$1200+$10+$50=$1260, where$1200is your principle,$10is the first month’s interest and$50is the amount you further deposited into your account.Now, as you have deposited

$50more, would the interest at the end of the second month and at the beginning of the third month be the same? Of course not.At the beginning of the second month, the net amount in your account is

$1260right? Then, as the interest rate is10%, so in that sense the annual interest using this new amount should be$1260*0.1*1=$126. So basically, the monthly interest this time becomes$126/12=$10.5. That means, at the end of the second month and at the beginning of the third month, the net amount in your account now is$1260+$10.5+$50=$1320.5, where$1260is the net amount at the beginning of the second month,$10.5is the monthly interest and$50is the amount you save every month. And the same procedure goes on for the rest of the months as you are depositing money every month into your account.For monthly compound interest, the procedure is mentioned in this article.

Hope, this clears your confusion. Have a great day.

Dear

COLYNN BURRELL,Thanks for reading our article. Try the following formula to resolve your issue.

`=IF(C5="Fail", TEXT("Replace, Review", "[$-409]@"), "")`

The formula indicates that if

cell C5contains textFail, then the formula will returnReplace, Review. If not, then the result it will return will be blank.Formula Breakdown●

TEXT(“Replace, Review”, “[$-409]@”)This formula returns

Replace, Revieweach time.●

IF(C5=”Fail”, TEXT(“Replace, Review”, “[$-409]@”), “”)This formula returns

Replace, Reviewonly for the text stringFail.Now to add

redcolor to the output, use theconditional formattingfeature as illustrated in this article.● Select the

range D5:D9.● Go through these steps:

Home >> Conditional Formatting >> New Rule.● Now, select

Format only cells that containfrom theSelect a Rule Typesection.● Select

Specific Text.● Type

Replace, Review.● Click on

Format.● Select

Font.● Click on the

arrow downicon in thecolorsection.● Select the color

red.● Click on

OK.● Click on

OKagain.● And the output will be as follows as you have desired.

Note:However, you can’t change the color of the output just after applying the formula. You have to use conditional formatting for that.If the problem still appears, kindly send us your Excel file and specify the exact problem you are facing.

Thank you

Best Wishes,

Raiyan Zaman AdreyDear

MARK GROENING,Thank you for reading our articles. You wanted a formula to delete any random number and leave only text.

You can follow method 3 and method 5 of this article for your problem. The formulas mentioned here should work with your problem.

Using formula of

method 3:=TEXTJOIN(“”, TRUE,IFERROR(MID(B5, SEQUENCE(LEN(B5)), 1) *1, “”))Using formula of

method 5:=SUM(MID(0&B5,LARGE(INDEX(ISNUMBER(–MID(B5,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1, 1)*10^ROW($1:$99)/10)Hope, this worked for your problem.

Regards,

Raiyan Zaman Adrey