View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tom tom is offline
external usenet poster
 
Posts: 570
Default New to Excel. Need help with formual

I am trying to perform a lookup but also do arithmetic calculations.

=SUM(B5 -3%(LOOKUP(B5,D5:F17)*?

B5 = 1000
? IS THE VALUE OF MY LOOKUP FORMULA

Kind regards