| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Between to values
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
| Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming | |||
Threaded Mode
