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

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
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)]))
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of NeilSchneider

NeilSchneider

  • 0 Points
Replace this line:

[Deluxe Trim]=true,

With

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


Neil