Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populating a Cell based on a Range of Values (Part II)
Sorry, but my I'm still not sure how to make my formula evaluate a full range
of values. For example, the cell I need to populate will have values based on what is calculated in another cell as follows: If value in cell A1 is 1.0 and 0 in new cell .900 - .999 1 in new cell .800 - .899 2 in new cell all the way down to <.100 which should put a 10 in the new cell. Thanks again for all the help! It is definitely a learning experience for me. Ken -- akkrug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a cell based on a range of values | New Users to Excel | |||
auto populating a cell based on another cell for an invoice | Excel Discussion (Misc queries) | |||
populating a cell based on another range of cells in excel | Excel Discussion (Misc queries) | |||
Populating a field based on lookup values | Excel Worksheet Functions | |||
Populating a table based on values in another table | Excel Worksheet Functions |