# How to generate report in Excel?

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.

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.

@elegnet

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,