Hi,
I'm trying to build a formula to calculate a Deal amout.
Here are the fields so far :
"Base Price" - checkbox
"Tech Package" - checkbox
"Nb of trainer(s)" - picklist, with the options : 1, 2, 3, 4 or 5
"Trainer (per day / per trainer)" - picklist with the options : 1, 2, 3, 4 or 5
I'm not good at all with formulas and custom functions; I want the formula field to calculate something like :
if ''Base Price'' is True, the value is 1000$
if ''Tech Package'' is True, the value is 500$
if ''Nb of trainer(s)'' is 1 the value is 1, 2 the value is 2, 3 the value is 3, 4 the value is 4, or 5 the value is 5, if nothing is selected, well nothing happened
if ''Trainer (per day / per trainer)'' is 1, the value is 1000$, 2 the value is 2000$, 3 the value is 3000$, 4 the value is 4000$ or 5 the value is 5000$, if nothing is selected, well nothing happened
then calculate a currency in the formula field = ''Base Price'' + ''Tech Package'' + ( ''Nb of trainer(s)'' * ''Trainer (per dat / per trainer)'' )
Is it possible ? Can you help me with the formula ?
Thank you all,