IF Formula

B

Bob

Here is a formula I need:
=IF(SUM(PreProduction!$Q7=1),"SUBMITTED"),IF(SUM(PreProduction!$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
 
B

Bob Phillips

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


--
HTH

Bob Phillips

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

Richard Wrigley

Suspect you need formula

=IF(SUM(PreProduction!$Q7=1),"SUBMITTED",IF(SUM(PreProduction!$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
 
Top