Using Multiple IF Statements with "AND" and "OR" and multiplication

[mbnumba6]

Hi Team,

I am trying to make an expression that auto calculates a price based on specific categories or columns a customer falls into.There are only 4 combinations. So that means I need an IF statement that looks at 4 different cases to calculate a price.

Example I have the following columns :

1. Type(Enum)
2. Service Lateral (Number)
3. Trenching (Enum)

The column “Type” and "Trenching only has two choices to choose from.

What I am trying to accomplish is something like this:

If (
Type = “Overhead”, Service Lateral Equals = 100 and Trenching = “Company”**
then multiply by 24.88

OR

If(
Type = “Underground”, Service Lateral = 100 and Trenching = “Customer”
Then multiply by 4.27

OR
If(
Type = “Overhead”, Service Lateral = 100 and Trenching = “Company”
Then multiply by 8.38

OR
If(
Type = “Underground”, Service Lateral = 100 and Trenching = “Company”
Then multiply by 20.42))

I looked at a few problems on this board already and where my confusion is coming from is using the AND/OR statements for multiple cases. Not sure where exactly to put AND. I am also unsure if I should use “IF” or “IFS”.

So this expression will take place in another column that is READ ONLY and it will calculate the price based on what was answered throughout the application. If there is another way to do this without IF statements I’m all ears.

Using multiple IFS statements or is there a different way? Questions

I need an expression to check multiple IFS and i cannot figure it out. What I have so far: IFS(( ([Antigen Results] <> “Positive”), ([PCR Results] <> “Positive”), “CLEAR”, ([Antigen Results] = “Positive”), ([PCR Results] = “Positive”), “ACTIVE”), TRUE) I want this expression to check multiple values and give a text value accordingly.

Here’s what I tried below just in case you are interested in how I was thinking:

IF(
AND(
[Type] = “Underground”,
[Trenching] = “Company”),
[Service lateral] * 20.42),

OR

IF(
AND(
[Type] = “Overhead”,
[Trenching] = “Company”),
[Service lateral] * 20.88),

IF(
AND(
blah blah blah))

Thank you in advanced