If Function ERROR
=IF(AND([Term length (Years)]@row >= 1, [Term length (Years)]@row <= 5, Referral@row = "External"), 0.03, IF(AND([Term length (Years)]@row >= 6, Referral@row = "External"), 0.03, IF(AND([Term length (Years)]@row >= 1, [Term length (Years)]@row <= 5, Referral@row = "None"), 0.07, IF(AND([Term length (Years)]@row >= 6, Referral@row = "None"), 0.07, IF(AND([Estimated Annual GP]@row >= 100000, Referral@row = "Internal"), 500, IF(AND([Estimated Annual GP]@row > 100000, Referral@row = "Internal"), 1000)))))
=IF(AND([Estimated Annual GP]@row >= 100000, Referral@row = "Internal"), 500, IF(AND([Estimated Annual GP]@row > 100000, Referral@row = "Internal"), 1000
I need to merge the two above functions. I keep getting a #UNPARSHABLE error.
I am sure it may be a simple error.
I was just able to get this one to work but it keeps putting 500.00% instead of 500.00. 1000 and 500 should be $500 and $1000 not a % like the other parts of the function.
=IF(AND([Term length (Years)]@row >= 1, [Term length (Years)]@row <= 5, Referral@row = "External"), 0.03, IF(AND([Term length (Years)]@row >= 6, Referral@row = "External"), 0.03, IF(AND([Term length (Years)]@row >= 1, [Term length (Years)]@row <= 5, Referral@row = "None"), 0.07, IF(AND([Term length (Years)]@row >= 6, Referral@row = "None"), 0.07, IF(AND([Estimated Annual GP]@row >= 100000, Referral@row = "Internal"), 500, IF(AND([Estimated Annual GP]@row > 100000, Referral@row = "Internal"), 1000))))))
Thank you for your help,
Patricia
Comments

Unfortunately you can only have one or the other. Either percentages or dollar amounts. You can adjust the format of cells individually, but that would have to be done manually.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!