HELP WITH FORMULA

A

acandray

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I NEED TO DETERMINE IF A VALUE IS BETWEEN A RANGE, FOR EXAMPLE, IF THE VALUE OF THE CELL IS 510, I WANT THE FORMULA TO DETERMINE A VALUE FOR FOR THREE CATEGORIES:
520
Click to expand...
500 TO 520
<500

IF IT IS >520 ASSIGN A VALUE OF 1
IF IT IS BETWEEN 500 AND 520 ASSIGN VALUE OF 2
AND <500 VALUE OF THREE

I HAVE ONLY BEEN ABLE TO USE THE FORMULA WITH THE >520 AND <500 BUT AM NOT ABLE TO BUILD THE FORMULA FOR THE RANGE >500 AND <520

THANKS!!!!
 
S

Skinman

Try
=IF(<500,3,IF(>520,1,2))
Skinman
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I NEED TO DETERMINE IF A VALUE IS BETWEEN A RANGE, FOR EXAMPLE, IF THE
VALUE OF THE CELL IS 510, I WANT THE FORMULA TO DETERMINE A VALUE FOR FOR
THREE CATEGORIES:

500 TO 520
<500

IF IT IS >520 ASSIGN A VALUE OF 1
IF IT IS BETWEEN 500 AND 520 ASSIGN VALUE OF 2
AND <500 VALUE OF THREE

I HAVE ONLY BEEN ABLE TO USE THE FORMULA WITH THE >520 AND <500 BUT AM NOT
ABLE TO BUILD THE FORMULA FOR THE RANGE >500 AND <520

THANKS!!!!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Specifying a point on each series in an X-Y scatter graph. 1
Copying email addresses into email 1
highlighting duplicate values in a column 3
How to count duplicates... 1
crashes beget new files 0
How to copy cells 4 times into next column 8
Formulas in Chart Titles Axis Titles 4
Value assigned to text 2

Top