Search results

Hi Bino, Thanks for sharing problem. I have modified your code and am sharing the workbook with you in the attachment. Download and run the code. And let us know the feedback. Regards, Ridwan

Hi Marc, As far I know, this happens when Excel faces any function of updated versions. You can try these possible solutions. Try the Ampersand (&) or CONCATENATE function instead of the CONCAT function as it was first introduced in the 2016 version. i. For using Ampersand (&) formula in cell...

Many Excel users need assistance in splitting a column in Excel into multiple segments, each limited to a certain number of characters, without cutting words. Suppose, I have a column in Excel (let's say Column A) with text data that needs to be divided into segments of 30 characters each...

Welcome, Marc. May I know which version of Microsoft Excel you use? From my end, the file is working fine in the Microsoft 365 version. The formula is created based on cell range A2:B26 with absolute reference. So if you shift the dataset, the formula will result in blank values. You can share a...

Hi Hajjash, Thanks for sharing your problem with us! I have solved your problem. [see the image below] Here, I have used an Excel SUMIFS formula that calculates the sum of values in column C (likely representing the number of visitors) based on three criteria. It considers only rows where the...

Hi cpetersen, Thanks for sharing your problem with us. I have inserted a new row for inserting the relevant code for ethnicity (e.g. A34:H34) Then, I inserted the following formula in cell A39 and dragged the Fill Handle till cell H39: =COUNTIFS($M$3:$M$27, "N", $L$3:$L$27, A34) Thus, I...

Hi ikweethetnietmeer, Thanks for sharing your problem with us. you can use the following formula in cell E3 and drag the fill handle down and right till the last cell to apply the same formula: =IFERROR(INDEX($B$2:$B$26,MATCH(CONCAT("*",$D3,E$2,"*"),$A$2:$A$26,0)),"") I am attaching the...

Hello Leslie, Thanks for your post. To calculate the internal growth rate, you can use the following formula: Internal Growth Rate = (Retained Earnings / Total Assets) * (1 + Dividend Payout Ratio) First, calculate the retained earnings. Retained earnings are the portion of the net income not...

Hello Leslie, Here is the solution to your problem. I have increased the cost and asset value proportionately with the increase in sales. Then, I have added the net income with debt and equity, and the sum of debt, equity, and net income is $16,392, but the asset is $16660. so I have to add...

Hello Leslie! All of your problems can be solved using the Excel Solver feature. I am sharing all the solutions in the attached Excel File and giving brief instructions so you can learn how to solve them yourself. Solution: Q1 Follow these steps: Create an Excel workbook and set up a table with...

Hello Leslie! The basic balance sheet equation is: Assets = Liabilities + Equity When incorporating net income and dividends, you need to consider their effects on equity: Assets = Liabilities + (Equity + Net Income - Dividends) You must make both side of same value else the balance sheet...

Hello Leslie! Thanks for your question. According to your dataset, I have created the calculation for Pro Forma year 1. You can check the image below, and the Excel file is attached to the reply. I have followed the below steps: Sales for Year 1 (Pro Forma Year 1): Calculate the 20%...

Hello Maps! You are a real Excel enthusiast, I must say. We are here to solve your problem. I have tried to solve what you wanted. I have inserted a formula to connect the working month with the annualized tax. Here is an idea from the gif: Also, I'm sharing the workbook with you. Have a great...

Hello Maps! I am seeing that the formula is giving the same result compared to the hand calculation that you have shared. for example 1: and for example 2: Point to be noted that: I have calculated the age from birth date till the tax end period. I hope the confusion will be solved. Regards...

Hello Maps! I hope you are having a good day. I have solved your problem. Here you can see the screenshot, and along with this, I am sharing the solved workbook with you. Please reply back if you have any further queries about this topic. And browse Exceldemy blogs for solving Excel related...