[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

  • Book2.xlsx
    11.4 KB · Views: 2
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

  • Book2.xlsx
    13.5 KB · Views: 2

Online statistics

Members online
0
Guests online
13
Total visitors
13

Forum statistics

Threads
292
Messages
1,268
Members
531
Latest member
lonkfps
Top