# How do I add an "OR" function to the formula I already have in place?

• 0
• Question
• Updated 3 years ago
I would like to add OR [Shelving]=true after [Deluxe Trim]=true,

CURRENT FORMULA:
If(
[Deluxe Trim]=true,
(3+
[Plan Take/Off - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off2 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off3 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off4 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off5 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off6 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off7 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off8 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off9 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off10 - PAINT INT TRIM (GAL)]),

([Plan Take/Off - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off2 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off3 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off4 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off5 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off6 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off7 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off8 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off9 - PAINT INT TRIM (GAL)]+
[Related Plan Take/Off10 - PAINT INT TRIM (GAL)]))
• 580 Points

Posted 3 years ago

• 0
• 0 Points
Replace this line:

[Deluxe Trim]=true,

With

([Deluxe Trim]=true OR [Shelving]=true),

Neil