need your help in formula

[G. Ram]

Dear all,
   I need your help in formula, i need correct formula to get daily total salary and ot amount..
please help me.. i have send the attachment too..

Thank&regards,
Ram,

[Sudheer N.A]

Dear Ram,
Here I'm attaching the file with two functions have been created.
Look cells D32 to J33.

function 1:
=daysal(col1,row1,row2,col2)

where
col1= the number of column for which date you need the totals ie,
a=1,b=2,c=3 and so on row1=the number of starting row from where you
want to sum the amounts here it's row number 8 row2=the number of row
up to where you want to sum the amounts here it's row number 29
col2= the number of column were you have given the daily rates that is
column number 13 for column "M"

function 2:
=dayot(col1,row1,row2,col2,otrate)

where
col1= the number of column for which date you need the totals ie,
a=1,b=2,c=3 and so on row1=the number of starting row from where you
want to sum the amounts here it's row number 8 row2=the number of row
up to where you want to sum the amounts here it's row number 29
col2= the number of column were you have given the daily rates that is
column number 13 for column "M"
otrate=rate of OT,or the cell address its entered. here its E1

But there is demerit to this functions.whenever you make changes in
the data area (if you put X,X/2 or remove or enter OT hours) the
function will not re-calculate its results.For this you have to
re-type the function again in the same cell.(select the cell,press F@
and press enter key).I hope some one in this group will help to
overcome this disadvantage with these functions

Regards -Sudheer

--
http://www.google.com/profiles/sudheer.na/

[Sixth Sense]

Hi Ram,

 

Herewith I have attached a modified excel file as per your requirement.  This is very easy to use and you are not needed to spend more time on preparing reports.

 

Whenever we are maintaining any records and we need to arrive some reports from it on a frequent basis then we should simplify it by choosing appropriate method.

 

Here I would suggest you to use the Pivot Table for preparing your reports.  Just open the file and have a look of it.  You should give your input only in the Master Data Sheet and just go to the other sheets and just place the cursor inside of the Pivot Table Reports and give Refresh. That's all the report will be updated.

 

Read the comments mentioned in Master Data Sheet from P7 to Q9 and do accordingly.

 

Hope that this will be useful for you...

 

' Happy Diwali '

 

Regards,

 

Sixthsense

[ramu]

Excellent !!!. mr.sixth sense. i am very thankful to you.

Thanks&regards,
Ram..

On Oct 17, 5:36 pm, Sixth Sense <sixthsens...@gmail.com> wrote:
> Hi Ram,
>
> Herewith I have attached a modified excel file as per your requirement.
> This is very easy to use and you are not needed to spend more time on
> preparing reports.
>
> Whenever we are maintaining any records and we need to arrive some reports
> from it on a frequent basis then we should simplify it by choosing
> appropriate method.
>
> Here I would suggest you to use the Pivot Table for preparing your reports.
> Just open the file and have a look of it.  You should give your input only
> in the Master Data Sheet and just go to the other sheets and just place the
> cursor inside of the Pivot Table Reports and give Refresh. That's all the
> report will be updated.
>
> Read the comments mentioned in Master Data Sheet from P7 to Q9 and do
> accordingly.
>
> Hope that this will be useful for you...
>
> ' Happy Diwali '
>
> Regards,
>
> Sixthsense
>

> On Mon, Sep 28, 2009 at 1:07 PM, G. Ram <grs1...@gmail.com> wrote:
> > Dear all,
> >    I need your help in formula, i need correct formula to get daily total
> > salary and ot amount..
> > please help me.. i have send the attachment too..
>
> > Thank&regards,
> > Ram,
>
>
>

>  SLY FINAL.xls
> 280KViewDownload