$1K to 5K, Microsoft Excel, newsgroup, help, assistance" /> $1K to 5K Excel Worksheet Functions" /> Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K - ExcelBanter

Menu

Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

jennifer

Posts: n/a

Default

Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K

Can you help please?

I am looking to assign ranges for values in a column, I want to assign a
range that based on that number in the adjoining column as follows.

100,001K plus
10,001 to 100K
5,001 to 10K
1,001 to 5K
0 to 1K

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 11:27 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement