Please Could somebody help me out on translate the following cal.
formula to
java function (in array)
1.)
If IsNull(x_LowOperatingRange.value) OR x_LowOperatingRange.value = "NA"
OR ((InStr(x_DeviceID.value, "PSH") > 0) And x_HighOperatingRange.value
<= 30 Then
PRE_SetPointPressure_.value + 5
ElseIf ((InStr(x_DeviceID.value, "PSH") > 0) And Round(x_HighOperatingRange.value * 1.15,0) > x_MAWP.value * 0.95 Then
PRE_SetPointPressure_.value = x_MAWP.value * 0.95
ElseIf ((InStr(x_DeviceID.value, "PSH") > 0) Then
PRE_idSetPointPressure_.value = Round(1.15 * x_HighOperatingRange.value,0)
ElseIf IsNull(x_LowOperatingRange.value) OR x_LowOperatingRange.value = "NA" OR ((InStr(x_DeviceID.value, "PAH") > 0) And Round(1.075 * x_HighOperatingRange.value,0) > 0.95 * x_MAWP.value Then
PRE_idSetPointPressure_.value = x_MAWP.value * 0.95
ElseIf ((InStr(x_DeviceID.value, "PAH") > 0) Then
PRE_SetPointPressure_.value = Round(1.075 * x_HighOperatingRange.value,0)
ElseIf IsNull(x_HighOperatingRange.value) OR x_LowOperatingRange.value
= "NA" OR ((InStr(x_DeviceID.value, "PSL") > 0) And x_LowOperatingRange.value <= 30 Then
PRE_SetPointPressure_.value = x_LowOperatingRange.value - 5
ElseIf ((InStr(x_DeviceID.value, "PSL") > 0) And x_LowOperatingRange.value
>= 31 Then
PRE_SetPointPressure_.value = Round(x_LowOperatingRange.value * 0.85,0)
ElseIf IsNull(x_HighOperatingRange.value) OR x_LowOperatingRange.value = "NA" OR ((InStr(x_DeviceID.value, "PSH") > 0) Then
PRE_SetPointPressure_.value = Round(0.925 * x_LowOperatingRange.value,0)
End If
Thanxs in advance