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)
```

Jim - The Monday Man (YouTube Channel)

**What is Make & How can it help you?**

**We Create Custom Solutions**

**Schedule a 1-on-1 Tutorial Session(monday, Make or Baking)**

1 Like

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

2 Likes

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