Forum Discussion

Kauphil's avatar
Kauphil
Copper Contributor
Sep 03, 2020
Solved

Band Billing

how do set a invoicing for water in excel which is paid for in bands i.e total usage is 100 cubic metres 0-30 cubic metress                 @1 USD per Cubic metre 31-70 Cubic metres                ...
Formulas and Functions
Bennadeau's avatar
Bennadeau
Iron Contributor
Sep 03, 2020

Hi Kauphil,

Try this...

=IF(A2<31,A2*1,IF(A2<71,30+(A2-30)*2,IF(A2>70,110+(A2-70)*3)))

Cell A2 is where you type in the usage and B2 should give you the pricing you are looking for.

 

  • Kauphil's avatar
    Kauphil
    Copper Contributor
    Sep 04, 2020

    Bennadeau thanks for this...

Resources