Forum Discussion

Copper Contributor

Dec 14, 2020

Need help with a formula

I try to make a formula where I get a specific number if another cell is within a certain range. I tried many different solutions but no success. Give it in text IF H3 is in the range 0-299 = 0...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Dec 14, 2020

Victor_Svensson

With some assumptions that could be

=LOOKUP(H3,{0,300,400,500},{0,5,7,15})

Victor_Svensson
Copper Contributor
Dec 14, 2020
SergeiBaklan

My Excel would not accept it as a formula.
- SergeiBaklan
  Diamond Contributor
  Dec 14, 2020
  Victor_Svensson
  
  Please open attached workbook and check within it how the formula looks for your locale.
  lookup h3.xlsx10 KB
  - Victor_Svensson
    Copper Contributor
    Dec 14, 2020
    SergeiBaklan
    
    =LETAUPP(H3;{0\300\400\500};{0\5\7\15})
    Thanks! It works!