Posts by Mariane Gobbato Basgal • 51 points
1 post
-
5
votes5
answers32003
viewsQ: 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?…