Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tier As Range Function
I am trying to understand why this function is producing weird
results. I feel like I have setup the function correctly, but the numbers being returned are not the numbers expected. Thanks for the help, Function FINDTier(ERNVAR, Tier As Range) Select Case ERNVAR Case Is 0.13: FINDTier = Tier(1) Case Is = 0.13: FINDTier = Tier(2) Case Is = 0.09: FINDTier = Tier(3) Case Is = 0.05: FINDTier = Tier(4) Case Is <= 0: FINDTier = Tier(5) Case Is <= -0.03: FINDTier = Tier(6) Case Is <= -0.07: FINDTier = Tier(7) Case Is < -0.12: FINDTier = Tier(8) End Select End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding quantity that falls within a range or Tier | Excel Worksheet Functions | |||
tier calculations | Excel Discussion (Misc queries) | |||
how to use tier system | Excel Worksheet Functions | |||
3-tier stacked bar chart | Charts and Charting in Excel | |||
tier pricing | Excel Worksheet Functions |