+ Reply to Thread
Results 1 to 8 of 8

PT Slab male and female

  1. #1
    Registered User
    Join Date
    01-28-2017
    Location
    nashik
    MS-Off Ver
    win-7
    Posts
    4

    Smile PT Slab male and female

    dear all,

    how to use gender wise calculation for pt slab

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,935

    Re: PT Slab male and female

    Hi, welcome to the forum

    Sorry, but I have no idea what you mean, you will need to give FAR more info that what you have. better yet, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: PT Slab male and female

    Dear Jaydev : On what connection do you calculated.
    You can differentiate total number (count) of male & female, Max & Min Age, Average Age, Total score (Marks & &) of male & female like this.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    01-28-2017
    Location
    nashik
    MS-Off Ver
    win-7
    Posts
    4

    Re: PT Slab male and female

    Quote Originally Posted by avk View Post
    Dear Jaydev : On what connection do you calculated.
    You can differentiate total number (count) of male & female, Max & Min Age, Average Age, Total score (Marks & &) of male & female like this.

    i dint count avg, age or

    i will calculate pt slab if male and female for exp
    male if male slab
    female if female slab

    diffrunt slab male or female i will put formula if male or female and so and so

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: PT Slab male and female

    Attach sample file with before (oriiginal data) & after (required result data) enter manually.

  6. #6
    Registered User
    Join Date
    01-28-2017
    Location
    nashik
    MS-Off Ver
    win-7
    Posts
    4

    Re: PT Slab male and female

    name gender Pt
    SHANKAR PANDHARE Male H 401 34 30 5300 3311 5300 3311 0 1148 9759 1,033 1,150 170.78 409.02 175 8380 11319 792 12111


    new pt slab is gender wise male slab and female slab i will create the formula if (male)(gross>175,0,if(gross >200)so and so
    i expected for formula gender+pt calculate plz suggest me

  7. #7
    Registered User
    Join Date
    01-28-2017
    Location
    nashik
    MS-Off Ver
    win-7
    Posts
    4

    Re: PT Slab male and female

    name gender Pt
    SHANKAR PANDHARE Male H 401 34 30 5300 3311 5300 3311 0 1148 9759 1,033 1,150 170.78 409.02 175 8380 11319 792 12111


    new pt slab is gender wise male slab and female slab i will create the formula if (male)(gross>175,0,if(gross >200)so and so
    i expected for formula gender+pt calculate plz suggest me

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: PT Slab male and female

    My first suggestion would be to use an online translator, like https://www.translate.com so that you can better relate your questions and explanations. Type out your questions and explanations in Marathi (listed official language) and let the translator change them to English, then paste the English translations here. You may also want to translate my post, which may make it easier to understand my suggestions.
    My second suggestion is actually a repeat of what FDibbins and AVK have already advised, upload a sample spreadsheet. To upload a spreadsheet press the Go Advanced button that is below Quick Reply window then scroll down to the Manage Attachments link to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically adding Mr or Ms to male/female
    By TTej in forum Excel General
    Replies: 7
    Last Post: 10-03-2017, 11:49 AM
  2. Getting totals for all male and all female
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-09-2014, 09:32 PM
  3. Male or Female Return Value
    By Doogster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2014, 04:19 AM
  4. [SOLVED] Link 2 different variables to Male/Female for no' alcohol units
    By Woody3ER in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2013, 03:50 AM
  5. [SOLVED] Formula for male and female staff on rota
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-06-2013, 07:03 AM
  6. Replies: 16
    Last Post: 01-16-2012, 07:09 AM
  7. Excel Male / Female Column
    By ringrim in forum Excel General
    Replies: 5
    Last Post: 08-13-2008, 05:28 PM
  8. IF male or female IF age is in range...THEN...
    By mtmagent in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-22-2006, 03:14 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1