Windows XP Gratuity Caclulation

[shashiraj75]

Hi Friends,

I need your help to calculate the Gratuity for my employees, i have 3 scenarios

1. Employees will be paid 21 days basic till they complete 5 years in the company
2. Once the employees complete 5 years, the following years will be paid 30 days basic
3. However from 01-01-2006 company has changed their policy, now it is 30 days basic

EX.

Employee DOJ Basic Gratuty till 31-12-2005, Gratuity from 2006
XYZ 01-01-2000 10,000.00 ??? ???

I need your urgent help yo sort out this issue

br
Raviraj Shetty

 

[Anon_F]

Use a Calculator?

 

[Ian]

I don't understand what you mean, could you explain it in a little more detail?

 

[Anon_F]

I think shashiraj75 wants us to do the calculation within excel for him/her?

 

[shashiraj75]

Hi Feckit

Yes you are right, i need in Excel, I missed to mention in the beginning.

 

[DigitalDoctorTech01]

Hire another employee to figure out your book-keeping and help out the economy instead of trying to get it done for free or pay one of us to do it!

 

[shashiraj75]

Hey Dgitial Doctor
Is this a joke or this is the way you people try to help out. If I would have knew that such stupid and arrogant people are there in this forum, then I wouldn't have discussed this matter.

This is a serious note that PCReview should consider and montiror the comments, which really hearts one's sentiments

Try to improve your behavious DOCTOR, otherwise patient's may kick you out

 

[Anon_F]

This is a serious note that PCReview should consider and montiror the comments, which really hearts one's sentiments

Try to improve your behavious DOCTOR, otherwise patient's may kick you out

Sadly your ploy to get us to do your work for you failed!
As for our comments, if you dont like them dont come back, oh don't think you have.
As for DigitalDoctorTech01, i dont think he's a real Doctor
Looking forward to you witty reply to this, now you have a nice day, now

 

[floppybootstomp]

One member does not sum up the view of the majority of this forum's members.

If this thread degenerates into a cat fight I'll lock it.

I'll agree it does seem a little cheeky but it's a legitimate software question so if anybody can help the guy out, please do so.

Myself, I haven't a clue

 

[xxcrimsonreddxx]

Hah, that guy thought he was a doctor.


nice.

 

[Adywebb]

feckit please remember that Mods can still read your deleted posts

 

[DigitalDoctorTech01]

This is my last post to this thread, as I too do not want this to degrade into useless arguing, but I really have no idea how to write the formula, If there was a problem with the excel program itself I could help more, but that is where my expertise ends. However, I will say the question does seem a bit cheeky, which is the only reason I responded the way I did.

P.S. I don't think I'm stupid...Am I?

 

[xxcrimsonreddxx]

nope.

sometimes tempers flare.

Lets move on, shall we?

 

[Anon_F]

feckit please remember that Mods can still read your deleted posts

Yes i know
I'm trying to be more diplomatic in my approach.