# 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.

– user55949
Commented Sep 26, 2019 at 9:26
• 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. Commented Sep 26, 2019 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.