[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
4
Guests online
338
Total visitors
342

Forum statistics

Threads
464
Messages
2,084
Members
5,842
Latest member
v79ad1
Back
Top