I have created a form that I need to implement an If Then statement. Basically if the answer to one field is less than 2.99 then I need a particular field to return an answer of 30.
Basically If Field A < 2.99 then Field B=30
If Field A >3.0 but less than 9.99 then Vield B =16
If Field A >10 but less than 29.99 then Field B = 11
If Field A >30 but less than >59.99 then Field B =10
If Field A is great than 60 then Field B = 8
Is their a way that this can be incorporated as a formula?
Thank you
Angie
You may have to do a careful analysis in order to get the logic right, but then, it is pretty simple and looks like this:
if (condition a) {
do action 1
} else {
if (condition b) {
do action 2
} else {
... etc.
}
}
Hint: in the above example, it would make most sense to test for the greatest value first, and then test in descending order...
Hope this can help.
Max.