Calculate a labor rate

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am trying to calculate a labor rate from a field called wage that could either be an hourly rate or an annual rate. Here is what I have so far:

If([Wage]>=$10,000.00, [Wage]/2080, [Wage])

I am lost. thank you for any help.
Photo of Ann Swelgin

Ann Swelgin

  • 120 Points 100 badge 2x thumb
  • confused

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
close, just drop the $ sign


If([Wage]>=10,000.00, [Wage]/2080, [Wage])
(Edited)
Photo of Ann Swelgin

Ann Swelgin

  • 120 Points 100 badge 2x thumb
I ended up with this and it works. then just had to format the field as currency.

If([Wage]>=10000, [Wage]/2080, [Wage])
Photo of Ann Swelgin

Ann Swelgin

  • 120 Points 100 badge 2x thumb
it's always a small thing that I miss :)