hi all

please i need help i want to calculate electricity bill in filemaker

if units between 1-1500 it will multiplied by 10

if units between 1501-3000 it will multiplied by 35

if units between 3001-4000 it will multiplied by 80

if units between +4000 it will multiplied by 120

on condition when the bill equal for exmple 6000 unite the first 1500 will multiply by 10 will remain 4500 the 3000 of 4500 will muliply by 35 the last 1500 will multiply by 80

Let ( [

units = 6000;

] ;

Case (units <= 1500 ; units * 10 ;

units <= 3000 ; ((units - 1500) * 35) + (1500 * 10) ;

units <= 4000 ; ((units - 3000) * 80) + (1500 * 10) + (1500 * 35);

((units - 4000) * 120) + (1500 * 10) + (1500 * 35) + (1000 * 80)

)

)