Formula for calculating the value of a field

[Juandbbam]

We want to create a formula to calculate the value of a field under the following conditions:

"If the value of the field with ID=23 is = to 2 months, then increase the value of the field with ID 24 by 10% and divide by 2, if the value of the field with ID=23 is = to 3 months, then increase the value of the field with ID 24 by 10% and divide by 3, and so… "

We have entered the following formula in a field and it does not work for us, could you tell us how should be the structure of the formula?

if( rgar( $form_data, ‘23’ ) == ‘2 meses’,
( rgar( $form_data, ‘24’ ) * 1.1 ) / 2,
if( rgar( $form_data, ‘23’ ) == ‘3 meses’,
( rgar( $form_data, ‘24’ ) * 1.1 ) / 3,
if( rgar( $form_data, ‘23’ ) == ‘4 meses’,
( rgar( $form_data, ‘24’ ) * 1.15 ) / 4,
rgar( $form_data, ‘24’ )
)
)

Thank you in advance!

[richardw8k (Richard Wawrzyniak (Gravity Forms))]

This isn’t supported out of the box. The team at Gravity Wiz have an add-on for advanced calculations:

Gravity Forms Advanced Calculations - Gravity Perks by Gravity Wiz

[scott-the-sorceror (Scott (Gravity Wiz))]

As Richard mentioned, Advanced Calculations is a good fit here. The calculation would look something like this:

if( F23 == 2 ):
	( F24 * 1.1 ) / 2
elseif( F23 == 3 ):
	( F24 * 1.1 ) / 3
elseif( F23 == 4 ):
	( F24 * 1.15 ) / 4
else:
	F24
endif;

Do note that Advanced Calculations cannot do if/elseif statements on strings, only numeric values. Assuming your 2/3/4 month values are in a choice-based field, you’ll need to set the values of those fields to be integers, like this:

[Juandbbam]

Thank you!