[Yend -Wage YTD]-[Yend - exemption] .How do I add? if the "total" is greater than 54,900 then enter 54,900 - I am a beginner - thank you

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am sure it's easy - I just haven't used formula's much. thank you
Photo of Carmen

Carmen

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
no problem

MIN([Yend -Wage YTD]-[Yend - exemption], 54900) 



What that means is to use the smaller of 54900 and that calculation.