Conditional formula problem

S

Spencer O.

I want to make a conditional formula with multiple variables, but I'm not
sure how (e.g. if B6<=5, display 1; if B6>5 but <=10, display 4; etc)
 
P

Peo Sjoblom

Nevermind, I misread your question.

put all the value in a table staring from 0 and use
VLOOKUP unless you only have a couple in case you already received and
answer for.

hard coded



=VLOOKUP(B6,{0,1;5,4;10,7;15,10;20,13;25,17;30,20},2)

that is up to 30 using imaginary values
--


Regards,


Peo Sjoblom
 
Top