How do I create multiple IF statements in a function

jordanlamagna

Here is my current formula for the column "Tech Setup Price"

=IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "Yes"), 650, IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "No"), 500, 0))

This does not include the below added variable of the Neo Modular System, so I want to add that variable. Basically, here is what I want:

$500 if tech set up is Yes and the frame is not curved

$650 if tech set up is Yes and EITHER the frame is curved OR the Frame Type is Neo Modular System

$0 if tech set up is No

Is this possible, or is this too much information for one function?

Thanks!

Mark.poole

@jordanlamagna

=IF(AND([Tech/Set Up]@row = "yes", OR([Is the frame curved? ]@row = "Yes", [Frame Type]@row = "Neo Modular System")), 650, IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "No"), 500, 0)

See if this adjustment to your original formula works for you. All I did was add an OR Statement to your original AND statement.

Leibel S

@jordanlamagna

The below should work:

=IF([Tech/Set Up]@row = "Yes", 500 + IF(OR([Is the frame curved?]@row = "Yes", [Frame Type]@row = "Neo Modular System"), 150, 0), 0)

Mark.poole

@jordanlamagna

=IF(AND([Tech/Set Up]@row = "yes", OR([Is the frame curved? ]@row = "Yes", [Frame Type]@row = "Neo Modular System")), 650, IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "No"), 500, 0)

See if this adjustment to your original formula works for you. All I did was add an OR Statement to your original AND statement.

jordanlamagna

Mark.poole

Feb 4, 2025

@jordanlamagna

=IF(AND([Tech/Set Up]@row = "yes", OR([Is the frame curved? ]@row = "Yes", [Frame Type]@row = "Neo Modular System")), 650, IF(AND([Tech/Set Up]@row = "yes", [Is the frame curved? ]@row = "No"), 500, 0)

See if this adjustment to your original formula works for you. All I did was add an OR Statement to your original AND statement.

Thank you! I thought I had tried using IF(OR, but I must've inputted it wrong somewhere.