Multiple Conditions Using Greater Than Less Than
I have a dilemma, and I can't figure it out.
Based on a a dollar value, I need the signature of a different person.
1 - 1000 = Senior Representative
1001.01 - 9999.99 = Supervisor
10000 and up = Manager
I need it to populate based on the above titles.
If the value is less than or equal to 1000, I need it to say "Senior
Representative".
If the value is between 1001.01 and 9999.99, I need it to say "Supervisor".
If the value is equal to or greater than 10000, I need it to say "Manager".
HELP!
|