formula help
 

Dear All,

I am new to excel and not good with formulas, my problem is i am trying to
make a daily and monthly reporting format, but a little problem i am facing.

I am doing entries of company's orderes and I want to make a reporting
format for daily basis as well as monthly report. but my problem is with
carried forwarded entries of previous day. ie.

i got today 30 order forms and yesterdays pending forms are 5 that means i
do have to make entries of total 35 order forms but by some reason 10 entries
remain pending today those will be carried forwarded on tomorrow. In my data
sheet there is formula (forms carried forwarded from y'day + forms recd today
= total forms for entry ) and (total forms for entry - forms entered today =
pending entries ) tha problem is i given a pestlink option to field (pending
forms) to next days (forms carried forwarded from y'day). this formula shows
figure of pending forms in next days carried forward field and pending forms
of all dates onwards.

It is showing pendancy unnesessarily, is there any formula or fuction by
using that tha pending forms figure will show only in next day and not in all
onward dates.

I tried a lot, but i hope i will get the solution of my problem from
community members. It may be very easy to do so but not for me. So please
help me.

Thanking you all in advance,

Aarif

formula help
 

One solution is to add an if statement. the following "formula would go into
the cell that hold the pending entries:
=if(forms entered today = 0,0,total forms for entry - forms entered today)
This presumes forms entered today is 0 until the day is current...

"Aarif" wrote:

Dear All,

I am new to excel and not good with formulas, my problem is i am trying to
make a daily and monthly reporting format, but a little problem i am facing.

I am doing entries of company's orderes and I want to make a reporting
format for daily basis as well as monthly report. but my problem is with
carried forwarded entries of previous day. ie.

i got today 30 order forms and yesterdays pending forms are 5 that means i
do have to make entries of total 35 order forms but by some reason 10 entries
remain pending today those will be carried forwarded on tomorrow. In my data
sheet there is formula (forms carried forwarded from y'day + forms recd today
= total forms for entry ) and (total forms for entry - forms entered today =
pending entries ) tha problem is i given a pestlink option to field (pending
forms) to next days (forms carried forwarded from y'day). this formula shows
figure of pending forms in next days carried forward field and pending forms
of all dates onwards.

It is showing pendancy unnesessarily, is there any formula or fuction by
using that tha pending forms figure will show only in next day and not in all
onward dates.

I tried a lot, but i hope i will get the solution of my problem from
community members. It may be very easy to do so but not for me. So please
help me.

Thanking you all in advance,

Aarif

formula help
 

Sean Timmons

Thanks a lot, it works.

Aarif

"Sean Timmons" wrote:

One solution is to add an if statement. the following "formula would go into
the cell that hold the pending entries:
=if(forms entered today = 0,0,total forms for entry - forms entered today)
This presumes forms entered today is 0 until the day is current...

"Aarif" wrote:

Dear All,

I am new to excel and not good with formulas, my problem is i am trying to
make a daily and monthly reporting format, but a little problem i am facing.

I am doing entries of company's orderes and I want to make a reporting
format for daily basis as well as monthly report. but my problem is with
carried forwarded entries of previous day. ie.

i got today 30 order forms and yesterdays pending forms are 5 that means i
do have to make entries of total 35 order forms but by some reason 10 entries
remain pending today those will be carried forwarded on tomorrow. In my data
sheet there is formula (forms carried forwarded from y'day + forms recd today
= total forms for entry ) and (total forms for entry - forms entered today =
pending entries ) tha problem is i given a pestlink option to field (pending
forms) to next days (forms carried forwarded from y'day). this formula shows
figure of pending forms in next days carried forward field and pending forms
of all dates onwards.

It is showing pendancy unnesessarily, is there any formula or fuction by
using that tha pending forms figure will show only in next day and not in all
onward dates.

I tried a lot, but i hope i will get the solution of my problem from
community members. It may be very easy to do so but not for me. So please
help me.

Thanking you all in advance,

Aarif