I am working on a pay change form. I need to calculate a value based on a condition. Here are my fields
Current pay rate=currency type
type of adjustment=choice column with choice of increase or decrease
amount of adjustment=currency
adjusted pay rate=currency
If the user selects increase for "type of adjustment" then the amount of adjustment needs added to the current pay rate and the adjusted pay rate needs populated with that amount.
If the user selects decrease then the amount of adjustment needs subtracted from the current pay rate and the adjusted pay rate needs populated with that amount. I did this in InfoPath at one point, but InfoPath has an "Action" rule available.