hi
i have written a function to calculate the total but it is only running the first if statement.please help this is my function:
=IIf(([Type of Freight]="Economy Part Load Vehicle" Or [Type of Freight]="Express Part Load Vehicle") And [Weight]>=0 And [Weight]<=2000 And [Kilograms]=2000,[Transport Fee]*[Weight],IIf(([Type of Freight]="Economy Part Load Vehicle" Or [Type of Freight]="Express Part Load Vehicle") And [Weight]>=2001 And [Weight]<=4000 And [Kilograms]=4000,[Transport Fee]*[Weight],IIf(([Type of Freight]="Economy Part Load Vehicle" Or [Type of Freight]="Express Part Load Vehicle") And [Weight]>=4001 And [Weight]<=6000 And [kilograms]=6000,[Transport Fee]*[Weight],IIf(([Type of Freight]="Economy Part Load Vehicle" Or [Type of Freight]="Express Part Load Vehicle") And [Weight]>=6001 And [Weight]<=8000 And [Kilograms]=8000,[Transport Fee]*[Weight],IIf(([Type of Freight]="Economy Part Load Vehicle" Or [Type of Freight]="Express Part Load Vehicle") And [Weight]>=8001 And [Weight]<=10000 And [Kilograms]=10000,IIf(([Type of Freight]="Economy Part Load Vehicle" Or [Type of Freight]="Express Part Load Vehicle") And [Weight]>=10001 And [Weight]<=15000 And [Kilograms]=15000,[Transport Fee],0))))))