Thread: Formula so if reference is selected, a specific value is returned
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BOSS BOSS is offline
external usenet poster
  
Posts: 123
Default Formula so if reference is selected, a specific value is returned
From a dropdown list I want to select from a range of set levels that have
specific values beside them. So when the range (0 - 600) is selected, $500
appears in another cell.
eg: 0 - 600 $500
600 - 1200 $1000
Reply With QuoteReply With Quote