Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Thanks, that seems to have sorted out the initial issue.

 

However, I have run into another problem. I need to add more If statements that will modify the size of the headbox (i have attached the table below to detail what is required). I have created the following code that seems to work for the first four statements, but the sizes do not change as they should.  

 

Is there a better code what i need? 

 

If 	s_o_width <=2500 AndAlso s_o_height <=1500
	headbox_depth = 125
	headbox_length = 150
	
Else If s_o_width >2500.01 <5000 AndAlso s_o_height <=1500
	headbox_depth = 150
	headbox_length = 150
	
Else If s_o_width <=2500 AndAlso s_o_height >1500.01 <3000
	headbox_depth = 150
	headbox_length = 150
	
Else If s_o_width >2500.01 <5000  AndAlso s_o_height >1500.0 <3000
	headbox_depth = 180
	headbox_length = 180

Else If s_o_width <= 2500 AndAlso s_o_height >3000.01 <6000
	headbox_depth = 180
	headbox_length = 180

Else If s_o_width >2500.01 <5000 AndAlso s_o_height >3000.01 <6000
	headbox_depth = 210
	headbox_length = 210
	
Else If s_o_width <= 2500 AndAlso s_o_height >6000.01 <9000
	headbox_depth = 210
	headbox_length = 210
	
Else If s_o_width >2500.01 <5000 AndAlso s_o_height >6000.01 <9000
	headbox_depth = 230
	headbox_length = 230
	
Else If s_o_width <= 2500 AndAlso s_o_height >9000.01 <12000
	headbox_depth = 230
	headbox_length = 230

Else If s_o_width >2500.01 <5000 Andalso s_o_height >9000.01 <12000
	headbox_depth = 250
	headbox_length = 250
	
End If