Thread: commission lookup
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default commission lookup
Or leave it as is and use this formula:
=IF($D1$B$1,10,IF($D1$B$2,9,IF($D1$B$3,8,IF($D1 $B$4,7,IF($D1$B$5,6,IF($D1$B$6,5,IF($D1$B$7,4, IF($D1$B$8,3,2))))))))
Reply With QuoteReply With Quote