calculate amount to be charged based on a cumulative weight break rate structure

Hi,

I suggest to used table to perform what you want.

Calculate each portion and sum together to get the final result.

if you prefer to use in one formula. i will try to assist you further.

unless this report is used by yourself, if not,
the complex formula sometimes it hard to understand by the client.

it more suitable to present in table form, as it more clear and easy to understand by other user.

it have better formula, but all i know is just combine all the formulas in one cell by add "+" in between formula.

Formula:

Please Login or Register  to view this content.