Calculate invoice discount based on repetitive value.

Hi there,


I want to make invoice which will calculate total based on discount circumstances. Invoice is meant for translation service.

I want to calculate special offer. The offer stands for translation service more than five pages per order, has every sixth page for free.

Every page is let's say 250 words. Word count is located in B2. Subtotal is located in E6 and Discount cell is located in E8.

All we know that every 5 page is 250*5 which equals 1250.

Is it possible to calculate discount based on these values, I really cannot understand how to calculate this or is it even possible.

Thank You for answering!


Oid83Vn.png

Hi

I suppose you want this

Formula:

Please Login or Register  to view this content.

or, in terms of Excel range

Formula:

Please Login or Register  to view this content.

See the file for clarification

Hi

Sorry for the mistake!

Try this

Formula:

Please Login or Register  to view this content.

Or

Formula:

Please Login or Register  to view this content.

Hey,

Thanks for reply.

Have you tried this yourself? Because i am getting an error with the first formula. The second formula have no error but still is not correct.

Please review with the file you sent.

Thank You so much!

Hi

I suppose this now works.

Formula:

Please Login or Register  to view this content.

See the file