Help With An IF Statement

[EYEMDABEST]

I have an IF statement that I wrote. When I try to apply the formula I get the error message

"Your formula is missing a parenthesis--) or (. Check the formula, and then add the parenthesis in the appropriate place."

I have looked at this for several hours and can't find what is missing could you please look this over and offer some assistance please.

IF(A2=Shrews,(ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB3!$A$3:$B$3000,2,0)/7),(K3/7)),0),IF(A2=Park,ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$E$3:$F$3000,2,0)/7),(K3/7)),0),IF(A2=MTGAY,ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$I$3:$J$3000,2,0)/7),(K3/7)),0),IF(A2=Buck,ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$M$3:$N$3000,2,0)/7),(K3/7)),0),IF(A2=Beck,ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$Q$3:$R$3000,2,0)/7),(K3/7)),0),0)

 

[JazzSP8]

Hi

Not sure if this is what your after but it seems like you might have got confused at some point while trying to get it to work;

=IF(A2="Shrews",ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB3!$A$3:$B$3000,2,FALSE)/7),(K3/7)),0),IF(A2="Park",ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$E$3:$F$3000,2,FALSE)/7),(K3/7)),0),IF(A2="MTGAY",ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$I$3:$J$3000,2,FALSE)/7),(K3/7)),0),IF(A2="Buck",ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$M$3:$N$3000,2,FALSE)/7),(K3/7)),0),IF(A2="Beck",ROUNDUP(IF(K3<1,(VLOOKUP(C3,WHB!$Q$3:$R$3000,2,FALSE)/7),(K3/7)),0),0)))))

(I also assumed that it was text values in A2 to avoid a #NAME error, you might want to change it back if thats not the case)

HTH