[Solved] want to know the error i did in this excel formula

Cyril Priya

New member
MonthShopsSalesRentSalaryElectricityTotal ExpensesProfit
AprilAbs &Co1,85,000
20,000​
32,000​
5,000​
57,000​
=sum(d2:f2)/h2 in this i am not geting the output
May2,35,356
15,253​
25,458​
25,458​
2,500​
53,416​
JuneBs&Co
35,458​
5,825​
45,000​
1,500​
52,325​
JulyRani&co
85,563​
65,689​
25,000​
3,500​
94,189​
AugustLg&Co7,45,896
7,560​
45,000​
1,500​
54,060​
SeptemberCss&Co5,25,236
4,850​
50,000​
5,000​
59,850​
OctoberKk&Co4,45,869
7,850​
45,000​
6,000​
58,850​
 

Attachments

Greetings Priya,

Below, I attached a file that has the solution to the problem that you asked for. The formula that you entered is not plausible in real life and will create confusion. The corrected profit calculation is now presented in cell H2. Moreover, other cells in the worksheet is now restructured and reformatted. If still have any more questions, please don't hesitate to contact us again.
 

Attachments

Online statistics

Members online
1
Guests online
159
Total visitors
160

Forum statistics

Threads
459
Messages
2,043
Members
2,318
Latest member
uy88playcomvn
Back
Top