How i can generate report in excel when data get form worksheet eg: result of students on one sheet when every print detail on student.
Please make your question clear. What exactly you want to do?
I don't think its possible in Excel. You might need SQL and Crystal Reports.
I am not clear from your question, however ur problem may be solved through pivot table report.
Obscure question, please try to rephrase it.
I want to know a formula for Excel...
The Case is as Follows:
In a company 1 day's salary is deducted for three Lates in any calendar month, I have done all other calculations and now a column shows number of days person is late in any calendar month..
Now i want a formula to calculate deductions from basic salary based on number of days person is late...
1-2 days late = NO deduction
3-5 days late = 1days salary deduction
6-8 days late =2 days and so on ( ie 1 day for every 3days late)...
Per day salary and all other thinks are already calculated..
I was trying Nest IF formula but i do not know where am I Wrong,
SOME ONE PLEASE HELP ME ON THIS ISSUE..
[quote=", post:, topic:"]
B2 : is the number of days an employee is late
Thank You Mr.KA..
The formula that you told me is working Good..