Hi,
I have spreadsheet, I'm not understanding how they calculating, please check the screenshot RED HIGHLIGHTED Cells, I need that formula how can this value is coming.
Advance Thanks
Hi,
I have spreadsheet, I'm not understanding how they calculating, please check the screenshot RED HIGHLIGHTED Cells, I need that formula how can this value is coming.
Advance Thanks
From the looks of it...
Net Ordinary Income / Gross Operating Inc. = % of Gross Income/net inc.
Ex: 54,608.57 / 74,705.67 = 0.73098294 ... approx: 0.73
Total Operating Expenses / Gross Operating Inc. = % income/expenses
Ex: 20,097.10 / 74,705.67 = 0.26901706 ... approx: 0.27
Hello Farhan
You need to upload a sample workbook.No one wants to type all the data shown in the screenshot
Best Regards
Imran Bhatti
Teach me Excel VBA
% Income/Expense = Total Expenses (20097) / Gross Operating Income (74605)
% of Gross Income/Net Inc = Net Operating Income (54608) / Gross Operating Income (74605)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks Richard and CK76, you are the best.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks