| 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Populating a cell based on a range of values
Hi Ken
Try this. =IF(A1=1,0,IF(A10.9,1,"")) Regards, Per "akkrug" skrev i meddelelsen ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Populating a cell based on a range of values
Thanks Per! I've got several more expressions I've got to include, but this
has definitely put me on the right track!! Have a great weekend! Ken K -- akkrug "Per Jessen" wrote: Hi Ken Try this. =IF(A1=1,0,IF(A10.9,1,"")) Regards, Per "akkrug" skrev i meddelelsen ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
