| 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. |
| 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 | |||
Threaded Mode
