Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Greater Less or Equal
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
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater Less or Equal
In article , TLAX wrote:
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 ... what do you think it should be ? :) If you have a go, people are more likely to help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater Less or Equal
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 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. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater Less or Equal
On Wed, 4 Sep 2013 03:51:08 +0100, TLAX wrote:
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 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Greater than or equal to | Excel Worksheet Functions | |||
Greater/Less Than or Equal To | Excel Discussion (Misc queries) | |||
greater than and equal to formulas | Excel Programming | |||
IF with Equal to or Greater than | Excel Discussion (Misc queries) | |||
Vlookup but also equal to and greater than? | Excel Worksheet Functions |