# More #UNPARSEABLE problems

Options
edited 12/09/19

Hi all

I have no idea why this is not working.  Here is the formula that I am trying:

=if([Opportunity Stage]1="Lead - Qualified",5%,if([Opportunity Stage]1="Scoping Requirements",10%,if([Opportunity Stage]1="Proposal/Quote/RFP Presented",25%,if([Opportunity Stage]1="Contract - Legal Review",40%,if([Opportunity Stage]1="Contract - Comments Received",60%,if([Opportunity Stage]1="Contract - Final Negotiation",75%,if([Opportunity Stage]1="Contract - Executable Sent",95%,0)))))))

I have tried changing this to just 1 if statement - =if([Opportunity Stage]1="Lead - Qualified",5%,0%) and I still get #UNPARSEABLE.

So frustrating!  Any help... ?

• ✭✭✭✭✭✭
Options

% in formulas need to be .75 or .1 without the %. Just format your column for %. If i update the numbers this works. I also added the @row:

=IF([Opportunity Stage]@row= "Lead - Qualified", 0.05, IF([Opportunity Stage]@row= "Scoping Requirements", 0.1, IF([Opportunity Stage]@row= "Proposal/Quote/RFP Presented", 0.25, IF([Opportunity Stage]@row= "Contract - Legal Review", 0.4, IF([Opportunity Stage]@row= "Contract - Comments Received", 0.6, IF([Opportunity Stage]@row= "Contract - Final Negotiation", 0.75, IF([Opportunity Stage]@row= "Contract - Executable Sent", 0.95, 0)))))))

• ✭✭✭✭✭✭
Options

Nic is correct. Percentages in formulas should always be set or called with decimals.

.25 = 25%

.5 = 50%

.75 = 75%

1 = 100%

There isn't much out there on this topic. But you can read some basic tips for working with formulas which includes this topic of percentages.