# Formula Struggle

Hi guys. Hoping someone can help me with this, probably something small I’m doing wrong but I’m a noob.

I’m trying to get a formula going, I currently have this which works great:

`IF(AND({Quantity}>=20,{Quantity}<=29,{Screens}=1),{Quantity}*1.2)`

But I need to also check different {Quantity} values & {Screens} values & multiply by a different figure. This is where I’m running into issues!

I have tried this:

``````IF(AND({Quantity}>=20,{Quantity}<=29,{Screens}=1),{Quantity}*1.2),(IF(AND{Quantity}>=100,{Quantity}<=199,{Screens}=1),{Quantity}*0.44)
``````

but doesn’t seem to work. Any help would be greatly appreciated!

@holebrain

Since your conditions are mutually exclusive, this should work:

``````IF(AND({Quantity}>=20, {Quantity}<=29, {Screens}=1), {Quantity}*1.2, 0) +
IF(AND{Quantity}>=100, {Quantity}<=199, {Screens}=1), {Quantity}*0.44, 0)
``````

But since you really have only 2 situations, this should work too:

``````IF(AND({Quantity}>=20, {Quantity}<=29, {Screens}=1), {Quantity}*1.2, {Quantity}*0.44, 0)
``````

1 Like

Jim, you’re a LEGEND . Thanks v much, I really appreciate it.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.