New to Excel. Need help with formual

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 24 Jun 2007 23:03 GMT

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 to this Message

JMB - 25 Jun 2007 00:27 GMT

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

> I am trying to perform a lookup but also do arithmetic calculations.
>
[quoted text clipped - 4 lines]
>
> Kind regards

Reply to this Message

CLR - 25 Jun 2007 16:50 GMT

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

> I am trying to perform a lookup but also do arithmetic calculations.
>
[quoted text clipped - 4 lines]
>
> Kind regards

Reply to this Message

Rate this thread: