to try to help with this formula. So do not point me to that please.
Basically I have field called Attorney Fee showing as currency. What I need is that whatever that inputted in there should reflect an amount shown in currency for our finance option.
$4500 attorney fee should show as $216.
If(Contains(${Leads.Attorney Fee}, '3500'),$168,
If(Contains(${Leads.Attorney Fee}, '4000'),$192,
If(Contains(${Leads.Attorney Fee}, '4500'),$216,
If(Contains(${Leads.Attorney Fee}, '4700'),$226,
If(Contains(${Leads.Attorney Fee}, '5200'),$250,
If(Contains(${Leads.Attorney Fee}, '5900'),$283,
If(Contains(${Leads.Attorney Fee}, '6200'),$298,
If(Contains(${Leads.Attorney Fee}, '6400'),$307,
If(Contains(${Leads.Attorney Fee}, '7900'),$379, 0 ) ) ) ) ) ) ) ) )
Thanks in advance.