Hello Forum,

I am new to this kind of function, not sure if i have posted in the right place. I am getting an #na error with the following, can anyone please explain where i am going wrong.

=IF(B12>999,(VLOOKUP(C2,RATEMASTER!$C$2:$H$20,6,FALSE)+B12*VLOOKUP(C2,RATEMASTER!$C$2:$H$20,7,FALSE))*VLOOKUP(C2,RATEMASTER!C2:H20,8,FALSE),IF(B12=500,VLOOKUP(C2,RATEMASTER!$C$2:$H$20,5,FALSE)*VLOOKUP(C2,RATEMASTER!$C$2:$H$20,8,FALSE),IF(B12=250,VLOOKUP(C2,RATEMASTER!$C$2:$H$20,4,FALSE)*VLOOKUP(C2,RATEMASTER!$C$2:$H$20,8,FALSE),0)))