Thread: New to Excel. Need help with formual
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default New to Excel. Need help with formual
Perhaps:
=B5-3%*LOOKUP(B5,D5:F17)



"Tom" wrote:

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
Reply With QuoteReply With Quote