If Function ERROR

phollingsworth79111

=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

Paul Newcome

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.