| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populating a cell based on a range of values
What is the best approach for populating a cell on a spreadsheet based on a
range of possible values. For example if the value in cell a1 =1, value in b1 should be 0, if the valued in cell a1 is .900 and <.999, cell b1 should be a 1. I wasn't sure if I should use the and function or a Vlookup. Sorry to bother everyone on a Friday! Ken K. - 2191 -- akkrug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| sum the values of a range based upon multiple ranges and criteria | Excel Worksheet Functions | |||
| Populating a table based on values in another table | Excel Worksheet Functions | |||
Threaded Mode
