+ Start a Discussion

Formula field gets populated with respect to other fields

Hi All,

Consider there are 3 custom fields A,B,C. A is the formula field, B is the currency field and C is the formula field which gets the output of either A or B based on user inputs. Guide me with the possibilities and formula syntax to generate the output for Field C.Im using PE.












By reading the requirement, i understand that you can use the following formula format to accomplish  what you qare trying to do:

IF(logical_test, value_if_true, value_if_false)


IF(user_field==XYZ, value from the formula field , value from currency field)


What I also understand is that if you want B as the value for a certain user value - the return type of the formula would have to be a currency.