| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if the value of a cell is between 2 values
I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000. and to 60 if between 5000 & 10000 by using formula. how can i do this. -- Harish B. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if the value of a cell is between 2 values
=IF(A2<2000,"",IF(A2<5000,30,IF(A2<10000,60,"")))
-- __________________________________ HTH Bob "Harish B" wrote in message ... I want to set value of a cell (h2) to 30 if the value of other cell (d2) is between 2000 & 5000. and to 60 if between 5000 & 10000 by using formula. how can i do this. -- Harish B. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if the value of a cell is between 2 values
=IF(AND(D2=2000,D2<=5000),30,IF(AND(D25000,D2<=1 0000),60,"what if d2<2000
or d210000")) Regards, Stefi €˛Harish B€¯ ezt Ć*rta: I want to set value of a cell (h2) to 30 if the value of other cell (d2) is between 2000 & 5000. and to 60 if between 5000 & 10000 by using formula. how can i do this. -- Harish B. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if the value of a cell is between 2 values
Try this !
=IF((d2=2000)*(d2<=5000),30,IF((d2=5000)*(d2<=10 000),60,"")) On Sep 11, 6:14*am, Harish B wrote: I want to set value of a cell (h2) to 30 if the value of other cell (d2) is between 2000 & 5000. and to 60 if between 5000 & 10000 by using formula. how can i do this. -- Harish B. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if the value of a cell is between 2 values
thank you, stefi
-- Harish B. "Stefi" wrote: =IF(AND(D2=2000,D2<=5000),30,IF(AND(D25000,D2<=1 0000),60,"what if d2<2000 or d210000")) Regards, Stefi €˛Harish B€¯ ezt Ć*rta: I want to set value of a cell (h2) to 30 if the value of other cell (d2) is between 2000 & 5000. and to 60 if between 5000 & 10000 by using formula. how can i do this. -- Harish B. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
Linear Mode
