Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula error: the ) is missing 1

Status
Not open for further replies.

ts04

Technical User
Jun 14, 2004
69
NL
Can somebody please tell me what is wrong with the following formula:

Average_Powder_Surface(tonumber({@Average_radiator_length}),tonumber({@Hoogte}),Tonumber(Split(TextLookupLine("File.ini","A"),"=")@[2]),Tonumber(Split(TextLookupLine("File.ini","B")),"=")[2]),Tonumber(Split(TextLookupLine("File.ini","C")),"=")[2]),Tonumber(Split(TextLookupLine("File.ini","D")),"=")[2]),Tonumber(Split(TextLookupLine("File.ini","E")),"=")[2]))

It calls the following function:

Function Average_Powder_Surface (A_Rad_L as number, hoogte as number, A as number, B as number, C as number, D as number, E as number) as number

Dim INI as string


INI = "I:\Algemeen\Bart\Crystal projects\Vakantie Project\PPG_AKZO\Parameters.ini"

Average_Powder_Surface = A*2*A_RAD_L+B*(A_RAD_L/C*(hoogte-2*D)+E*(hoogte+A_Rad_L)*2)+A*2*A_Rad_L+B*(A_Rad_L/C)*(hoogte-2*D)

End Function

The error says:

The ) is missing. The cursor then points to the point in the formula where I have placed the @.

Thanx in advance!

Tanja
 
Try this:
Average_Powder_Surface(tonumber({@Average_radiator_length}),tonumber({@Hoogte}),Tonumber(Split(TextLookupLine("File.ini","A"),"=")@[2]),Tonumber(Split(TextLookupLine("File.ini","B"),"=")[2]),Tonumber(Split(TextLookupLine("File.ini","C"),"=")[2]),Tonumber(Split(TextLookupLine("File.ini","D"),"=")[2]),Tonumber(Split(TextLookupLine("File.ini","E"),"=")[2]))


Amber [peace]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top