The check is made progressively, so you don't need a lower bound
If TemperaturInput <= 10 Then
PoFResult = 5
ElseIf TemperaturInput =< 15 Then
PoFResult = 4
10 or less would be assigned a 5 in this case because it meets the first
criteria. Anything greater than 10 would go to the EndIF to be evaluated.
Items Less than or equal to 15 (but only those greater than 10 would get
this far) would be assigned 4
--
Regards,
Tom Ogilvy
"Michael" wrote in message
...
Thank's
I didn't think about the exact numbers 15, 20 etc
Could i use something like this.
If TemperaturInput <= 10 Then
PoFResult = 5
ElseIf TemperaturInput = 10 And TemperaturInput =< 15 Then
PoFResult = 4
or
If TemperaturInput <10 Then
PoFResult = 5
elseif TemperaturInput = 10 then
PoFResult = 5
"Bob Phillips" wrote:
You want AND
If TemperaturInput < 10 Then
PoFResult = 5
ElseIf TemperaturInput 10 And TemperaturInput < 15 Then
PoFResult = 4
ElseIf TemperaturInput 15 And TemperaturInput < 20 Then
PoFResult = 3
ElseIf TemperaturInput 20 And TemperaturInput < 25 Then
PoFResult = 2
ElseIf TemperaturInput 25 Then
PoFResult = 1
End If
But waht about 15, 20 and 25. You test for and < but not =.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Michael" wrote in message
...
Hi!
I have a VB formula that look like this.
TemperaturInput=FrmSeawaterParameter25CrSDSS.TxtTe mperature.Value
If TemperaturInput < 10 Then
PoFResult = 5
ElseIf TemperaturInput 10 Or TemperaturInput < 15 Then
PoFResult = 4
ElseIf TemperaturInput 15 Or TemperaturInput < 20 Then
PoFResult = 3
ElseIf TemperaturInput 20 Or TemperaturInput < 25 Then
PoFResult = 2
ElseIf TemperaturInput 25 Then
PoFResult = 1
End If
My problem is that this is not correct, if a set TemperaturInput=17 on
this
i will get
PoFResult =4 and that is NOT correct!
What is wrong?