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)

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 :musical_note: LEGEND :musical_note:. 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.