Question about Excel (SS8SATAS5128400R)

# 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

• Level 1:

An expert who has achieved level 1.

• Contributor

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

Hi,
a 6ya Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### How can I calculate the EMI of a home loan of 90 lacs?

Banks and Non-Banking Financial Companies use the following formula to calculate EMI of a home loan. This is the formula for calculating compound interest. Applying the same formula for a home loan of Rs 90Lakhs, we get,

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where,
P= Amount borrowed- Here, it will be 90 lakhs
R= Rate of interest per month
N= Number of months in the home loan tenure

Going by the current lending rates followed by the financial institutions, we will consider R to be 9% per annum (to be converted to % per month) and for the loan tenure, we will take 20 years/240 months.

Substituting all values in the above formula, the home loan EMI comes out to be Rs 80,975 per month.

You can easily calculate the EMI for your home loan for any bank or NBFC using a free online Home Loan EMI calculator. You can also find this handy tool on the online portals of most banks and NBFCs. All you have to do is feed in the values in the respective fields and receive the answers.

Oct 09, 2017 | The Office Equipment & Supplies

### 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

### 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

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

### 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

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

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

### 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

### 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

#### Related Topics:

88 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 2 Expert