Help me to build IF function for my production schedule>>>URGENT>>>>

Good day,

Kindly pls help to build the right IF function formula for production schedule. The
details as per below.

Total amount (qty)=30,000
Daily output= 1,500
2nd process required qty/day=1,200
2nd process date (reference)=8 June 05
1st process date (start)= should DEDUCT 5 days from 2nd process date (3 june 05)


So, as refer to above condition, pls help me to calculate 1st process output from 3 june onwards by using right "IF" function?

I would like to know hown many days the process take?

GREAT APPRECIATION ON YOUR HELP..........


From,
Syima

Total amount (qty)=30,000
Daily output= 1,500
2nd process required qty/day=1,200
2nd process date (reference)=8 June 05
1st process date (start)= should DEDUCT 5 days from 2nd process date (3 june 05)

Daily o/p 1500 and total quantity 30000, that means nos of days would be 20 (i.e. 30000 / 1500)

Also 2nd process 1200, and daily is 1500, therefore 1st process is 300 (i.e. 1500 - 1200)

Start date is 3-jun, what is end-date.

Your query is not clear enough

- Mangesh

The 2nd process date : from 8 june 05 until 25 june 05
The 1st process: from 3 june until 20 june 05

so, what the right IF function?pls help

What is it that you want to compare with an IF statement. As of now, from the data you have given, the number of days i get is 20 as explained in my earlier post. If you can explain me what you are trying to do, and your expected answer, then someone here would be able to help you. Forget excel, and the if statement, explain your process what you are trying to do as if you are writing on a piece of paper.

- Mangesh