Here is a formula I need:
=IF(SUM(PreProduction!$Q7=1),"SUBMITTED"),IF(SUM(P reProduction!$Q7+PreProduction!$S7=2),"APPROVED")

The first pat of this IF formula works
=IF(SUM(PreProduction!$Q7=1),"SUBMITTED")

The second IF does not and I get an error.
What is wrong in the formula?

Thanks for your help.
Bob

=IF(SUM(PreProduction!$Q7=1),"SUBMITTED",IF(SUM(Pr eProduction!$Q7,PreProduct
ion!$S7)=2,"APPROVED",""))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bob" wrote in message
...
Here is a formula I need:

=IF(SUM(PreProduction!$Q7=1),"SUBMITTED"),IF(SUM(P reProduction!$Q7+PreProduc
tion!$S7=2),"APPROVED")

The first pat of this IF formula works
=IF(SUM(PreProduction!$Q7=1),"SUBMITTED")

The second IF does not and I get an error.
What is wrong in the formula?

Thanks for your help.
Bob

Suspect you need formula

=IF(SUM(PreProduction!$Q7=1),"SUBMITTED",IF(SUM(Pr eProduction!$Q7+PreProduct
ion!$S7=2),"APPROVED", xxxx)

in xxxx put what to do if SUM(PreProduction!$Q7=1) is neither 1 nor 2

--
Richard.

"I have yet to see any problem, however complicated, which when looked at in
the right way, did not become still more complicated"
Poul Anderson