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

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

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