greater than less that plus add

Hoops · Mar 17th 2017

what is the formula to if B1 id greater than 0 but less than six add A1*1, if B1 is greater than 5 but less that 11 add A1*2, if B1 is greater than 10 but less than 16 add A1*2 plus A2*1, if B1 is greater than15 but less than 21 add A1*2 plus A2*2

**Carim** · Mar 17th 2017

Re: greater than less that plus add

Hello,

Not sure to fully understand ...

You could test following:

Code

=CHOOSE(MATCH(B1,{0,5,11,16},1),$A$1*1,$A$1*2,$A$1*2+$A$1*1,$A$1*2+$A$1*2)

Hope this will help

Hoops · Mar 17th 2017

Re: greater than less that plus add

thanks VB will try it out

**pike** · Mar 18th 2017

Re: greater than less that plus add

maybe just
[COLOR="#000080"]=CHOOSE(MATCH(B1,{0,5,11,16},1),$A$1,$A$1*2,$A$1*3,$A$1*4) [/COLOR]

greater than less that plus add

Participate now!

Share