Page 1 of 2 12 LastLast
Results 1 to 12 of 16

Thread: excel formula/functioning help

  1. #1
    Prince1's Avatar
    Prince1 is offline Senior Member+
    Last Online
    1st August 2010 @ 11:30 AM
    Join Date
    08 Dec 2008
    Age
    37
    Posts
    43
    Threads
    7
    Credits
    827
    Thanked
    3

    Exclamation excel formula/functioning help

    Main chahta hoon k koi aisa formula ho k Number of challans ka jo violation code hain wo violation codes main ajain aur unka jo fine wala column ha us kay mutabik fine bhi fine walay column main ajaye kyoun har violation code ma fine ki variation ha means agar 18 number code pe van ha to uska fine rikshay kai liyay aur ha aur van coaster wagera k liyay aur ha but 18 number ka saray fine ka total chahay wo koi b ho 18 number kai samnay hi aye kindly help me out on this issue thanks.
    Attached Images Attached Images  
    Attached Files Attached Files
    I Proud to be a Muslim!!!

  2. #2
    Saleem_sullo's Avatar
    Saleem_sullo is offline Senior Member+
    Last Online
    10th November 2016 @ 01:46 AM
    Join Date
    07 Nov 2009
    Location
    Multan
    Gender
    Male
    Posts
    5,910
    Threads
    87
    Credits
    1,203
    Thanked
    481

    Default

    excel main total auto kam naheen hota. is kam kay liye ap ko ya tu access main koi format banana ho ga. ya phir ko java main chota sa software bana lo.

  3. #3
    Prince1's Avatar
    Prince1 is offline Senior Member+
    Last Online
    1st August 2010 @ 11:30 AM
    Join Date
    08 Dec 2008
    Age
    37
    Posts
    43
    Threads
    7
    Credits
    827
    Thanked
    3

    Default

    to sarkar aap bana k do na main to tiflay maktab hoon :S:S

  4. #4
    Saleem_sullo's Avatar
    Saleem_sullo is offline Senior Member+
    Last Online
    10th November 2016 @ 01:46 AM
    Join Date
    07 Nov 2009
    Location
    Multan
    Gender
    Male
    Posts
    5,910
    Threads
    87
    Credits
    1,203
    Thanked
    481

    Default

    Quote Prince1 said: View Post
    to sarkar aap bana k do na main to tiflay maktab hoon :S:S
    tu sarkar ap jin ki taraf say challan kattay ho un ko kaho sarki tor par banwa dain.
    kon say office ( city ) say ho?

  5. #5
    denzees is offline Senior Member+
    Last Online
    21st June 2018 @ 01:58 AM
    Join Date
    07 Feb 2009
    Location
    Lahore
    Gender
    Male
    Posts
    58
    Threads
    12
    Credits
    1,030
    Thanked
    6

    Default Problem hal ho sakti hey.

    AOA!

    I hope k main aap k problem hal kar sakta hon lakin main app ki batai hoi tafseel se is problem ko samaj nahin saka. kindly mujhe zara tafseel se apni problem batain or sath main jo sheet aap ne attach ki hey us par proper headings bi dain. code or values repeat ho rahi hain so I am confused.

  6. #6
    Prince1's Avatar
    Prince1 is offline Senior Member+
    Last Online
    1st August 2010 @ 11:30 AM
    Join Date
    08 Dec 2008
    Age
    37
    Posts
    43
    Threads
    7
    Credits
    827
    Thanked
    3

    Default

    Quote saleem_sullo said: View Post


    tu sarkar ap jin ki taraf say challan kattay ho un ko kaho sarki tor par banwa dain.
    kon say office ( city ) say ho?
    itni hamari sarkar achi hoti to ap bhayoun sai madad mangtay?

  7. #7
    Prince1's Avatar
    Prince1 is offline Senior Member+
    Last Online
    1st August 2010 @ 11:30 AM
    Join Date
    08 Dec 2008
    Age
    37
    Posts
    43
    Threads
    7
    Credits
    827
    Thanked
    3

    Default

    Quote saleem_sullo said: View Post


    tu sarkar ap jin ki taraf say challan kattay ho un ko kaho sarki tor par banwa dain.
    kon say office ( city ) say ho?
    yar sarkar itni achi nae ha iss liyay ap bhayou sai help mang raha hoon kindly help kar dain please.............

  8. #8
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    The file is attached but it is still INCOMPLETE.
    There are two confusions:
    1) The column No of Challans is also counting IMPOUND or only CHALLANED ?
    2) In data, you have mentioned four vehicles; Rikshaw, Van, Coaster and Bus. But Bus is not mentioned in the summary table under Rate of Fine column.
    Attached Files Attached Files

  9. #9
    Prince1's Avatar
    Prince1 is offline Senior Member+
    Last Online
    1st August 2010 @ 11:30 AM
    Join Date
    08 Dec 2008
    Age
    37
    Posts
    43
    Threads
    7
    Credits
    827
    Thanked
    3

    Default

    The Column number of challans is counting only violations which include impounds and challans also under various violation codes rate for vans coasters and busses are same.

  10. #10
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    The file is attached.
    Total in the above data and the summary data is NOT the same, the reason is:

    Sr. 76 has fine 100, it should be 200 as VAN fine is 200 for code 6.
    Sr. 25 has fine 200, it should be 300 as VAN fine is 300 for code 19.
    Sr. 196 has code 18+6 which is invalid.
    Attached Files Attached Files

  11. #11
    Prince1's Avatar
    Prince1 is offline Senior Member+
    Last Online
    1st August 2010 @ 11:30 AM
    Join Date
    08 Dec 2008
    Age
    37
    Posts
    43
    Threads
    7
    Credits
    827
    Thanked
    3

    Default

    actually i have changed alignment of the column violation code and according to violation code fine is also changed thats why its wrong i think now you are clear?

  12. #12
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    There is also an easy formula to do all this.

    =SUMIF(G2:G238,code,H2:H238)
    Replace the code with the violation codes (1,2,3 .... 19).

Page 1 of 2 12 LastLast

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. Excel formula
    By naeemshahzad in forum Ask an Expert
    Replies: 0
    Last Post: 22nd March 2015, 12:22 PM
  3. help in excel formula
    By sabir sami in forum Ask an Expert
    Replies: 1
    Last Post: 26th August 2011, 01:25 PM
  4. MS Excel "IF" functioning help please
    By Prince1 in forum Solved Problems (IT)
    Replies: 12
    Last Post: 23rd July 2010, 06:07 PM
  5. excel formula need
    By alim khan in forum Ask an Expert
    Replies: 6
    Last Post: 11th April 2010, 10:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •