Populating a cell based on a range of values

  • Thread starter Thread starter akkrug
  • Start date Start date
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
 
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
 
Back
Top