ExcelBanter - New to Excel. Need help with formual

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - New to Excel. Need help with formual (https://www.excelbanter.com/new-users-excel/147774-new-excel-need-help-formual.html)

tom

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

JMB

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

CLR

New to Excel. Need help with formual

I'm not clear on exactly what you are wanting to do. Perhaps if you
re-stated your question, we might be of more help.

Vaya con Dios,
Chuck, CABGx3

"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

All times are GMT +1. The time now is 05:40 AM.