# Formula Parse error

Trying to use this formula in Google Sheets but getting a #error! parse error. Any help as to what may be wrong in the above formula

=if(AND(B4="YES",G4=0),(ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35%*12)),(IF(AND(C4="NO",F4>10),(ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35*12)),(IF(F4<=10),(ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*25%*12)),0))))

The above formula is to come up with limits based on the above parameters being:

B: Existing Customer
C: Has purchased a service making him not eligible for the current one
F: Daily ctivity (Number of hours active)
G: Outstanding dues
I,K,M,O,Q,S: 6 week earnings

I tried a couple of things but the parse message still comes up every time I try and execute this.

• A description what the various columns mean isn't actually as relevant as the data type which I assume is B:YES/NO, C:YES/NO, F-S: Numerical. Would be great if you could add that information. – Cornelius Roemer Sep 26 at 14:14

=IF(AND(B4="YES",G4=0),ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35*12),IF(AND(C4="NO",F4>10),ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35*12),IF(AND(C4="NO",F4>10),ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35*12),IF(F4<=10,(ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*25*12)),0))))
Problem 1: You're writing 35%* and 25%* that doesn't work
Style tip: You don't need to put arguments to formulae in brackets like AND((IF(a,b,c),(IF(a,b,c))); AND(IF(a,b,c),IF(a,b,c)) works just fine. Your formula is very difficult to decipher because of that.