Junior Member

Posts: 3

If value between 2 numbers

I am working on an inventory spreadsheet. The formula I need help with is IF("VLOOKUP VALUE") is between 1-19 then "LOW"; IF "VALUE" between 20-49 then "MEDIUM"; IF "VALUE" between 50-74 then "HIGH"; IF "VALUE" = 75 then "HEAVY".

I hope that makes sense. Thanks.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to reconcile numbers accounting Harlan Grove code doesn't work for negative numbers	[email protected]	Excel Programming	1	July 28th 06 07:09 AM
Excel Formula - Add column of numbers but ignore negative numbers	view for Distribution List members	Excel Worksheet Functions	1	April 7th 06 03:13 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	3	January 19th 06 09:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	1	January 9th 06 01:23 PM

All times are GMT +1. The time now is 01:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us