View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joao Lopes Joao Lopes is offline
external usenet poster
 
Posts: 1
Default How to assign values to a cell based on values in another cell?

I'm trying to figure out a way to automaticcaly assign values to a cell (B3)
based on values typed on cell A3. Example:
A3 values (typed) = 10%, 30%, 50%, 70%, 100%
B3 values (automatically assigned) = min, low, medium, high, max

Tks for the help.