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
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!