Automatically add when multiplied by

[pona88]

An attachment has been added to explain the issue more clearly

ORIGINAL MESSAGE:

Hi all

The title might not be fitting, but here is my question.

Is it possible to add a specific number, when you multiply by a specific number aswell?

Example:

Work hours: 4, 8, 12, 16

Price rate per hour: 500 kr.

Transport: 2000 kr. per day (1 day = hours)

If I have a service job of 8 hours and one of 16 hours.

=sum(8*500)+2000 = 6000 kr.
=sum(16*500)+4000 = 12000 kr.

Is it possible to create a formula which automatically adds 2000 kr. when you multiply by 8, as shown in the example above. And also add 4000 kr. when you multiply by 16.

If there is no formula which fits this request, then maybe there is a macro? I simply can not find an example of this particular case. I hope you can help.

Thanks in advance
Søren, Denmark

[AliGW]

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand.

[AliGW]

I have NO IDEA what you are asking.

[ChemistB]

I agree with Ali, that it might be clearer if you explained in your text.
My best guess is that in B3 copied down

Please Login or Register  to view this content.

This assumes,
1. We are only talking about service here and not transport
2. Your "Service Times" in Col A will never be less than 4.

[pona88]

Hi again

I had written an explanation, but I forgot to attach the workbook. I edited the post to attach the workbook, not realizing I had to rewrite the post before saving changes. When I saved the only thing left of the post was the file. Is there a way to delete this thread, or does an administrator need to get notified? I will post a new thread, once this has been deleted.

Sorry for any inconvenience.
Søren, Denmark

[AliGW]

There's absolutely no need to start a new thread!

Just tell us what you are trying to do.

EDIT: I've just reinstated the text of your opening post.

[Glenn Kennedy]

What are your expected answers for 2 hr and for 5 hr?

Does this work for both scenarios?

=A3*$E$3+ROUNDUP(A3/8,0)*$E$4

[pona88]

I agree with Ali, that it might be clearer if you explained in your text.
My best guess is that in B3 copied down

Please Login or Register  to view this content.

This assumes,
1. We are only talking about service here and not transport
2. Your "Service Times" in Col A will never be less than 4.

Thanks for your answer. I can not seem to make this work. I am still a beginner but eager to learn more. What does VLOOKUP do?

There's absolutely no need to start a new thread!

Just tell us what you are trying to do.

EDIT: I've just reinstated the text of your opening post.

Thanks a lot AliGW. Again, I am sorry for the rough start on this thread. It was not intentional.

What are your expected answers for 2 hr and for 5 hr?

Does this work for both scenarios?

=A3*$E$3+ROUNDUP(A3/8,0)*$E$4

Thank you Glenn. That works perfectly :D

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

[pona88]

Of course. Done and done.