=IF(A1<=1000,"Senior Representative",IF(A1=10000,"Manager","Supervisor "))

--
HTH,
Laura Cook
Neenah, WI


"Paperback Writer" wrote in
message ...
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!