Posts by Mariane Gobbato Basgal • 51 points

• 5

  votes

  5

  answers

  32003

  views

  Q: what formula do I make for ranges of values in excel?

  I need a formula in excel that identifies ranges, e.g. 0-30 = 20% 31-60 = 98,5% 61-90 = 100% 91-120 = 101,5% if f2<= 30 inform 20%; if f2>30 and <60 inform 98,5%, etc. How do I do?…

  excel fórmula

  asked 6 years, 10 months ago Mariane Gobbato Basgal 51