Greater Less or Equal

T

TLAX

When the value of a cell is less than or equal to 550 the value i
another cell should be 1, greater than 550 but less than or equal t
1100 the value in another cell should be 2, greater than 1100 but les
than or equal to 1650. Pleae provide a for formula for thi
 
B

Bruce Sinclair

When the value of a cell is less than or equal to 550 the value in
another cell should be 1, greater than 550 but less than or equal to
1100 the value in another cell should be 2, greater than 1100 but less
than or equal to 1650. Pleae provide a for formula for this
Click to expand...

... what do you think it should be ? :)

If you have a go, people are more likely to help.
 
C

Claus Busch

Hi,

Am Wed, 4 Sep 2013 03:51:08 +0100 schrieb TLAX:
When the value of a cell is less than or equal to 550 the value in
another cell should be 1, greater than 550 but less than or equal to
1100 the value in another cell should be 2, greater than 1100 but less
than or equal to 1650. Pleae provide a for formula for this
Click to expand...

your value in A1. Then try:
=VLOOKUP(A1,{0,1;551,2;1101,3;1651,""},2,1)
Suit the separators to your system


Regards
Claus B.
 
S

Stan Brown

When the value of a cell is less than or equal to 550 the value in
another cell should be 1, greater than 550 but less than or equal to
1100 the value in another cell should be 2, greater than 1100 but less
than or equal to 1650. Pleae provide a for formula for this
Click to expand...

This sounds like a homework problem. But even if it's not, you will
learn more by at least trying it yourself and THEN asking for help.
Include your attempts.
 
Top