AnsweredAssumed Answered

needing help to calculate

Question asked by mohammedkhaleel on Jun 14, 2018
Latest reply on Jun 18, 2018 by mohammedkhaleel

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