You are viewing limited content. For full access, please sign in.

Question

Question

Formulas in forms

asked on August 2, 2018

Hi everyone, I am trying to figure out the appropriate formula for the following fields in my Payroll Form. If the "Amount Remaining" field is LOWER than the "amount being claimed" field I want that number to automatically populate in the "Amount Available for Reimbursement" and if the "Amount being Claimed" is equal to or less than the "Amount Remaining" I want that number to automatically populate in the "Amount Available" field. I can figure this out in Excel but not in Forms, I must be missing something? Any help would be appreciated.

 

0 0

Replies

replied on August 2, 2018

The function should be essentially the same as what you would use in Excel

=IF(AmountRemaining<AmountClaimed,AmountRemaining,AmountClaimed)

Just make sure your variable names match since what I have here isn't necessarily what you named your variables.

Are you seeing any error messages, or are you just not getting a value? Also, are any of these fields in a Table or Collection, because that changes things a bit.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.