Need help with formula that adds 3 fields for a single total.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I am trying to add 3 fields if they are checked to equal a single $ amount. I cannot get the formula to work. Here is what I am trying to do:

If([Tech No-Show or Arrive Late ($50.00):]=true,50 + [Not Received Day of Install ($25.00):]=true,25 + [Not Received at All ($100.00):]=true,100)

Photo of Judi

Judi

  • 0 Points

Posted 4 years ago

  • 0
  • 1
If([field one]=true,50,0)+
If([field two]=true,25,0)+
If([field three]=true,100,0)