Expression Help

[Hammer]

I have the following sum in an excel spreadsheet which I want to replicate in access, can any one help.

the Excel sum is =if(b38=0,0,min(1,b38/(b34*24))) this basically works out a precentage of vehicle fill I.E b38 = Pallets despatched (17) and b34 is the max number of pallets I can get on a vehicle (24) therefore 17/24 = 71%.

I have the same info in access and have tried to enter the expression as

=if([sum of sum of pals out]=0,0,min(1,[sum of sum of pals out]/[sum of sum of No loads]*24))

I keep getting an error message of "The expression you entered is missing a closing Parenthesis, bracket (]) or vertical bar (I). I have tried moving the brackets around etc but I can't get it to work

[weekend00]

In Access, you should use IIF instead of IF; and there is no MIN function in Access.

=iif([sum of sum of No loads]=0,0,Iif([sum of sum of pals out]/[sum of sum of No loads]*24 <1,1,[sum of sum of pals out]/[sum of sum of No loads]*24))

[ConneXionLost]

Ignore this; duplicate post.