Multiple if by diferent numbers if between several ranges??

[odin679]

Hello,

Need help....

Collum x is 20 then 20*6.84 but if its above 20 and bellow 30 then 20*6.84+10*4.56 (this part i got it) BUT!!! If above 30 then 20*6.84+10*4.56+(whatever above 30) *1.5

Ex: 45
20*6.84+10*4.56+15*1.5

What I got so far:

=IF(G4<=20;G4*6,84;IF(G4>=30;20*6,84+(G4-20)*4,56;20*6,84+(G4-20)*4,56))

 

[odin679]

Let me try and explain a little better.

Collum A1 is a number that if is 20 or bellow will be multiplied by 6,84.
If above 20 and bellow 30 I'll have 20 * 6,84 + X*4,56 (where X is a number bettewn 21 and 30)
If above 30 I'll have 20*6,84 + 10*4,56 + X*1.5 (where X is a number above 31)

 

[odin679]

Ok, think I got it....

=IF(B3<=20;B3*6.84;IF(AND(B3>=21;B3<=30);20*6.84+(B3-20)*4.56;IF(B3>=31;20*6.84+10*4.56+(B3-30)*1.5)))

 

[DanteAmor]

Try this:

=IF(B3<21,B3*6.84,IF(B3<31,20*6.84+(B3-20)*4.56,20*6.84+10*4.56+(B3-30)*1.5))