Populating a cell based on a range of values

A

akkrug

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
 
A

akkrug

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating a Cell based on a Range of Values (Part II) 6
Excel In Excel how can I block the contenent of a cell? 0
Retrieve last non zero value in a range of cells 2
Reset Bottom of an Excel spreadhseet 1
default values in a cell 1
Lookup function to cell containing multiple values 3
Displaying a range based on a cell's contents 3
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Top