Help using IF function (Paranthesis error)

[cndu]

Hi All,

First of all I want to apologise for me not being able to communicate the issue in a tone that you would understand, Kindly bear with me and try to understand my following problem.

1. I have to get a start date for a particular activity, the start date cell is followed by the respective days of a particular week.
2. I use this sheet to track the status of the project (for design in particular).
3. The sheet is simple, it'll ask how many days left to finish the activitiy, and if it is a carry over job or not.

Now, I have tried to create a start date for a particular sheet (1 sheet for 1 week). But I'm unable to create a formula whenever the job is carry forward to next week.

I'm attaching my design status report for your reference. This is my formula, Kindly help. (it says the formula is missing an opening or closing parenthesis)

=IF(F8="NO",IF(J8="",IF(K8="",IF(L8="",IF(M8="",IF(N8="",IF(O8="","",$O$7),$N$7),$M$7),$L$7),$K$7),$J$7, IF(F8="YES", 'Design Status - Week 42'!G8, 'Design Status - Week 41'!G8

[AliGW]

Which cell should this go into?

[cndu]

Thank You for your response AliGW,

The formula should go into G8 of Design Status Report Week 43 sheet.

[JohnTopley]

Try ...

=IF(F8="NO",IF(J8="",IF(K8="",IF(L8="",IF(M8="",IF(N8="",IF(O8="","",$O$7),$N$7),$M$7),$L$7),$K$7),$J$7),IF(F8="YES",'Design Status - Week 42'!G8,'Design Status - Week 41'!G8))

[cndu]

Try ...

=IF(F8="NO",IF(J8="",IF(K8="",IF(L8="",IF(M8="",IF(N8="",IF(O8="","",$O$7),$N$7),$M$7),$L$7),$K$7),$J$7),IF(F8="YES",'Design Status - Week 42'!G8,'Design Status - Week 41'!G8))

Thank You Thank You Thanks a lot....