View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shek5150 Shek5150 is offline
external usenet poster
 
Posts: 14
Default Auto populate cell

How do I auto populate a cell based upon the value of another cell.

For example, If value in cell A1 is between 1-5, then I'd want the value of
B1 to auto populate w/ a designated text lable of "Mild"...or if the value in
cell A1 was between 6-10, then the value of B1 would auto populate w/ the
designated text lable of "Moderate." Etc...

Thanks in advance for any assistance w/ this issue.

Steve