| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions Using Greater Than Less Than
Try this:
=IF(A1<=1000,"Senior Representative",IF(A1<10000,"Supervisor","Manager" )) HTH, Elkar "Paperback Writer" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions Using Greater Than Less Than
=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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Conditions Using Greater Than Less Than
THAT DID IT!!!!!!!!
THANK YOU!!!!!! "Elkar" wrote: Try this: =IF(A1<=1000,"Senior Representative",IF(A1<10000,"Supervisor","Manager" )) HTH, Elkar "Paperback Writer" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Conditions within an IF Function | Excel Worksheet Functions | |||
| Multiple conditions for conditional formatting | Excel Worksheet Functions | |||
| multiple conditions | Excel Worksheet Functions | |||
| Lookup with multiple conditions | Excel Discussion (Misc queries) | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
Linear Mode
