dear all,
how to use gender wise calculation for pt slab
dear all,
how to use gender wise calculation for pt slab
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
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".
Attach sample file with before (oriiginal data) & after (required result data) enter manually.
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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks