Question about Excel (SS8SATAS5128400R)

1 Answer

Calculate a bill

Calculation of electricity bill provided rates for units <=50 is Rs 2, >50n <=100 is Rs 3, >100 n <=300 is RS 4 per unit ,.. find out the bill for 40 units , 88 units , 280 units etc

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Hi you can Apply below mention formula
=ABS(SUM(COUNTIF(RANGE,"CATAGARI")-(COUNTIF(RANGE,"CATAGARI")))

RANGE = FROM WHICH CELL TO YOU WANT TO APPLY THIS FORMULA TO TILL WHICH CELL.
CATAGARI = WHAT DO U WANT < FOR FOR FIRST > FOR SECOND

Posted on Jul 07, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What are the criteria decided by the Agriculture Minister of Chhattisgarh to help the drought hit farmers of 2015?


Today Mr. Brijmohan Agrawal is known for his commitment towards finanacial expand rate inirrigation and horticulture division of Chhattisgarh. In 2014 he was praised with the KRUSHI KARMAN recompense from the focal government for state`s record creation of grains.
Different policy plans propelled by our Agriculture Minister for the advantages of ranchers. As per information got, the agriculturists who did not have pumps would moreover be met all requirements for draw the benefit of Government plan yet the strategy of pumps should be done by him. Favorable circumstances will be ensured to an agriculturist against two hectare land said Irrigation Minister BrijMohan Agrawal.
As per the round, agriculturists of locales which recorded precipitation less that 50 percent till July 15 and zone purported drought hit by the State government will be fit the bill for the stipend.
So additionally, the agriculturists which did not get precipitation for 15 days after July 15, 60 percent precipitation or under 60 percent would moreover be entitled for the point of preference. The agriculturist of areas fitting in with tehsils announced as drought hit by the Government and did not have watering framework office watering framework would similarly be met all requirements for the point of interest.

Apr 18, 2016 | Computers & Internet

1 Answer

What price I can expect 3 BHK flat in Alpine Eco in Bangalore?


3BHK Independent floor in Alpine Eco cost between Rs 8000 to Rs 9000 per sqft. The value of unit varies on account of its location , builder, finishings etc.

Dec 01, 2014 | The Computers & Internet

1 Answer

A shortage of 100 kgs in chemical A, of 140 Kgs in chemical B and Of 50 kgs in chemical C was noticed due to breakages. At Mumbai, the manufacture paid octroi duty @ 0.20 kg. He also paid hamali, Rs 20 for...












CASE STUDY - 1






























Chemical A

Chemical B

Chemical C


Qty(Kgs)

Rate (Rs.)

Amount(Rs.)

Qty(Kgs)

Rate (Rs.)

Amount(Rs.)

Qty(Kgs)

Rate (Rs.)

Amount(Rs.)

Cost of Chemicals

6,000.00

4.20

25,200.00

10,000.00

3.80

38,000.00

4,000.00

4.75

19,000.00

VAT



630.00



950.00



475.00

Railway Freight



300.00



500.00



200.00

Octroi 2%



504.00



760.00



380.00

Hamali



20.00



58.12



30.75

Total Cost

6,000.00


26,654.00

10,000.00


40,268.12

4,000.00


20,085.75

Less: Shortage

-100



-140



-50



Net Qty Received

5,900.00


26,654.00

9,860.00


40268.12

3,950.00


20085.75

Normal loss

-236



-394



-158




NEED ANSWERS CONTACT ME AT aravind.banakar@gmail.com M : 09901366442 / 09902787224

Aug 30, 2011 | Computers & Internet

1 Answer

Write a program that will compute water bill


You don't say what programming language you're using, so I can't give you a finished program. I wouldn't anyway since you should do your own homework. But here's a suggestion for how to do it.

All the program needs to do is make some simple calculations. Your total bill will be determined by how much water you've used, based on whatever price per unit the supplier charges. If the program is very simple, you can just assign a rate, prompt for the user to input the amount of water used, do the calculation and display the result.

A more complex, real-world billing program will need to do more calculations, but it's all simple adjustment. There may be different rates used for commercial customers and residential users. The rate may vary depending on how much water was used during the billing cycle. There may be fees added (sewage treatment, for instance), and these may be flat charges or depend on water usage. You'll probably have taxes to add in as well, possibly several levels (local, state, etc.). You will need to get all this information in to the program, either assigning the values to constant variables, taking it from the user during the program, or calculating it as necessary.

But basically all your program will need to do is the calculation total bill = water used * rate + all other costs.

How fancy the program needs to be is up to you, based on the requirements set out by your instructor. It may simply display total bill amount on the screen. Or you may need to format and print a paper bill with all the information, like a real supplier would send out. Good luck, and thanks for using Fixya!

Mar 12, 2011 | Microsoft Computers & Internet

1 Answer

On annual instalment of Rs. 20000 Compounded annually for 12 years, if we get Rs. 450000 on maturity, what is the rate of interest


About 10.84%

If you want to know how to calculate this on your calculator, you'll have to tell us the make and model of the calculator.

Mar 01, 2011 | Office Equipment & Supplies

1 Answer

How to write an electricity bill in c program(9'th class)


#include <iostream.h>
#include <conio.h>
int main()
{
clrscr();
long int units,charge=0;
float total;
const int rent=25;
cout << "Enter the number of units used : ";
cin>>units;
if(units>200)
charge=(units-200)*20+150*40+50*60;
else if(units>50)
charge=(units-50)*40+50*60;
else
charge=units*60;
total=0.01*charge+rent;
cout << "You have used " << units << " units." << endl;
cout << "Your total telephone bill is $" << total;
getch();
return 0;


Please accept the solution. Thanks, Lucy
}
This program takes in the number of units used ('units') as a screen input from the user.
It then calculates the total telephone bill for the customer on the following basis :
A compulsory fee of $25, plus
60 cents per unit for the first 50 units,
40 cents per unit for the next 150 units,
20 cents per unit for anything above 200 units.
It then outputs the bill using the 'cout' command.

Jan 12, 2011 | Microsoft Computers & Internet

1 Answer

Rs 232 port in the HP 48GX


Try http://www.fixthatcalc.com/. A friend of a friend sent his HP 48 in for repairs. You may want to check into them.

Sep 22, 2008 | HP 48gx Calculator

1 Answer

COMPOUND INTEREST CUMULATIVE AMOUNT


after 3 years u wil get rs 43692..

Aug 29, 2008 | Office Equipment & Supplies

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

87 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

3020 Answers

Bill Boyd

Level 3 Expert

34329 Answers

Lala

Level 2 Expert

34 Answers

Are you an Excel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...