Add 20% to numbers under, Add 15% to numbers between, Add 10% to numbers over!

**Eagle75au** · 07-04-2012, 03:23 AM

As the title states i need to Add 20% to numbers under 200, Add 15% to numbers between 200 & 300 and add 10% to numbers over 300!

Thanks

**Ace_XL** · 07-04-2012, 03:27 AM

Try

=IF(A1<200,A1*1.2,IF(A1<300,A1*1.15,A1*1.1))

where A1 contains the data

**Fotis1991** · 07-04-2012, 03:31 AM

=if(a1<200,a1*1.2,if(and(a1<=300,a1>=200),a1*1.15,a1*1.1))

**zbor** · 07-04-2012, 03:41 AM

Originally Posted by Fotis1991

a1<200....(and(a1<=300,a1>=200)

Why check twice?

If is not <200 then why to check is it >=200?

**Fotis1991** · 07-04-2012, 03:59 AM

So? Just to be sure!

As i understand you like more this edition..

=IF(A1<200,A3*1.2,IF(A3<=300,A3*1.15,A3*1.1))

**Kyle123** · 07-04-2012, 04:08 AM

I'd prefer:

PHP Code:


=A1*LOOKUP(A1,{0,200,300},{1.2,1.15,1.1})

Re: Add 20% to numbers under, Add 15% to numbers between, Add 10% to numbers over!