Google Sheets (Excel): How Do I Iterate a Multiplier, Based on A Supplied Value -


i'm need know how achieve following scenario using google sheets / excel. apologize if subject wasn't accurate, challenging put words. :)

(where "x" variable supplied user; "y" multiplier applied forumla)....

if x < 10,000 y = 1; if 20,000 > x >= 10,000 y = 2; if 30,000 > x >= 20,000 y = 3; etc...

how create formula without having hard-code every possible if statement in order increment "y"?

thanks in advance everyone. appreciate amount of you're able offer.

if steps incremental, example formula simple:

y=int(x/10000)+1 

if not simple example using table vlookup easier , allow changes made without rewriting nasty nested if():

on 1 sheet put table of thresholds , multiplier:

enter image description here

then simple vlookup() find correct multiplier:

=vlookup(d2,$a$1:$b$8,2) 

enter image description here


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -