Conditional Statement

[paula]

Hello, I need a quick help.

How do I insert this one statement into the AND statement, I tried a lot I can't get where I am supposed to place it. Thank you!

[TeeSee1]

An AND expression is a list of yes/no expressions separated by comma..

AND( y/n, y/n,....)

https://support.google.com/appsheet/answer/10107398?hl=en

[paula]

Yes, but I don't where I should place it. Can you please show me where it should be placed instead? Thanks!

[TeeSee1]

You have two expressions within the AND. Just insert your additional yes/no after them

AND([_THIS..] , [_THIS...] ,  HERE  )

Just pay attention to your parenthesis.

[paula]

I tried, but still no. I can't see my mistake. Can you point it out when you see please? Thank you!

[TeeSee1]

 can you paste text (not an image) so I can copy, edit?

[paula]

AND([_THISROW_BEFORE].[LV3 Approval] <> "Approved", [_THISROW_AFTER].[LV3 Approval] = "Approved", [Gross Profit Rate] < 15%, ISBLANK([LV4 Approval]))

[TeeSee1 · Accepted solution]

AND(
 [_THISROW_BEFORE].[LV3 Approval] <> "Approved", 
 [_THISROW_AFTER].[LV3 Approval] = "Approved", 
 [Gross Profit Rate] < 0.15, 
 ISBLANK([LV4 Approval])
)

[TeeSee1]

Also what is the type of [Gross Proft Rate]?,

I also suspect that "15%" is not valid but should be 0.15 instead.

[paula]

It is a Percent. then being compared to another percentage

[TeeSee1]

Percent is (I am guessing) actually a decimal with a wrapper for notation.

Use 0.15 instead of 15%

[paula]

If I'm gonna be using Decimal in the automation condition, does that mean I will change the type of Gross Profit Rate to 'Decimal' too?

[TeeSee1]

You can continue to use Percent. Just use decimal values in expressions.

10% -> 0.1, 25% -> 0.25 etc.

[paula]

Really thanks a lot Mr. @TeeSee1  !