# Excel aata hai kya?

Discussion in 'Software Q&A' started by linardni, Sep 26, 2005.

Tags:
Not open for further replies.
1. ### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
Hi...can anyone help me with the following problem of excel. Please. Just tell me what formula is to be inserted in cell F2.
1) calculate total calls.
2) Calculate Amount per connection as Rs.0 for first 500 calls, Rs.1.00 per call for next 300 calls, Rs.1.50 per call for next 400 calls and Rs.2.00 per call for rest if nature of connection is "Domestic", but if it is "Business" type charge will be different. Nil for first 500 calls, Rs.1.20 per call for next 300 calls, Rs.1.50 per call for next 400 calls and Rs.1.75 per call for rest.

Tel Opng Call Clsng Call Total Nature of Conn Bill Amnt
24035546 13948 14753 Domestic
24034242 17989 19159 Domestic
24785546 38906 39933 Domestic
Service Tax @ 10.2%
Rental Charge Rs.400 per connection
Net Total

2. ### godsownmanNew Member

Joined:
Feb 22, 2005
Messages:
879
0
Trophy Points:
0
Location:
Bombay

Please if possible post a screenshot of the excel table.

3. ### ishaanNew Member

Joined:
Feb 28, 2004
Messages:
894
0
Trophy Points:
0
Location:
New Delhi
this is what u hafta do, from scratch.

make a subheading on top - domestic.
make 2 colums - CALLS and COST.
make the rows of diff call charges.
then make a row called total domestic calls.

make 2 clomuns - CALLS n COST.
make the rows of diff call charges here also.
then make a row total business calls.

then, as u use the phone, keep updating itunder the CALLS place.

in the COST place, put the formula for the cell of the CALLS multiplied by its cost.

do this for all of em

then in the end make a TOTAL CHARGE row

and put a fucntion for the SUM of the total of each business and domestic.

seems pretty complicated if u want i can make one for u n send it.

------------------

sorry...while i was riting this u edited ur post so i din c da bottom part. its kinda tuff 2 understand cud u upload the file somewhere so v can dload n c ?

4. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
by the way...how do i upload an excel file...plz help

5. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal

6. ### QwertyManiacCommander in Chief

Joined:
Jul 17, 2005
Messages:
6,656
10
Trophy Points:
0
7. ### expertno.1New Member

Joined:
May 16, 2005
Messages:
2,480
0
Trophy Points:
0
Location:
Expert Planet
What happend ?

Do you get an error ?

ok try this one
http://photobucket.com/

Thanks
Regards..
Expertno.1

8. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
9. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
10. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
yaaaah! i have uploaded.....now tell me the way of solving the problem

11. ### sakumar79Active Member

Joined:
Nov 28, 2004
Messages:
2,440
9
Trophy Points:
38
Location:
Create two extra columns (which u can hide/protect if necessary) that track number of business calls upto that row. Ie, if X and Y are the columns, in the 10th row, if value in col E (E10) is business, X10=X9+D10 and Y10=Y9, else, X10=X9 and Y10=Y9+D10. Then, look at E10 along with X10 or Y10 (IF E10 is Business then use X10 for number of calls made, else use Y10 for number of calls made) and calculate cost of that call. Proceed this way till the last line, then add basic cost and then service tax...

U might want to put a copy of the total somewhere at the top to make it easier to read without having to scroll.

Hope this helps.
Arun

12. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
sorry buddy...i want some formula to be inserted in the cells of F Column so that the result is automatically deducted.....i want to use logic function to solve it.

13. ### amit_stgNew Member

Joined:
Sep 25, 2005
Messages:
29
0
Trophy Points:
0
Location:
india
i dont think this can be solved just by typing a single function is f column for the entire calculation, you will need more no of columns (may be hidden) because this type of calculations needs mare than one calculated values.

14. ### vigneshNew Member

Joined:
Jul 20, 2004
Messages:
1,658
0
Trophy Points:
0
Location:
Chennai

15. OP

### linardniMember

Joined:
May 7, 2004
Messages:
199
0
Trophy Points:
16
Location:
Rampurhat, Birbhum, West Bengal
@vignesh
Hi...i dont think u will have difficulty in understanding the problem of excel. however i am once posting it for u....plz try
1) calculate total calls.
2) Calculate Amount per connection as Rs.0 for first 500 calls, Rs.1.00 per call for next 300 calls, Rs.1.50 per call for next 400 calls and Rs.2.00 per call for rest if nature of connection is "Domestic", but if it is "Business" type charge will be different. Nil for first 500 calls, Rs.1.20 per call for next 300 calls, Rs.1.50 per call for next 400 calls and Rs.1.75 per call for rest.

16. ### sakumar79Active Member

Joined:
Nov 28, 2004
Messages:
2,440
9
Trophy Points:
38
Location: