Using null statement in If statement formula

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

Hello! I am trying to create an If statement formula that when a numeric - currency field is not null, the formula would read the value in that field, and if it IS null, something else would happen. 

I'd like the formula to read something like this: 

If([Discretionary Rate] is NOT null, [Discretionary Rate], If [Discretionary Rate IS null and ([Overtime]=true,[Estimated Hours]*([Overtime Burden Rate]+[Estimated Rate]), [Estimated Hours]*([Estimated Burden]+[Estimated Rate])) 

Thank you!!

Photo of Heather Bryant

Heather Bryant

  • 20 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
Try this

If(
not IsNull([Discretionary Rate]), [Discretionary Rate],
[Overtime]=true,[Estimated Hours]*([Overtime Burden Rate]+[Estimated Rate]),
[Estimated Hours]*([Estimated Burden]+[Estimated Rate]))
Photo of Heather Bryant

Heather Bryant

  • 20 Points
Hi Mark, Thanks. That got rid of the error message but now the second and third parts of the formula are not working. I'll keep playing around with it.
Photo of Heather Bryant

Heather Bryant

  • 20 Points
never mind! I had the 'treat blank as zero' turned on. When I turned that off it worked. Thanks Mark - you the man!