excel formula to access expression

[rtilson]

I am not sure why excel and access use the same method in formula. I am not access expert but been trying to figure it out.

Here is the excel formula that I would like to use in access expression

=ROUND((A2-5148000)*1.0004 40935+48000,IF( MOD(A2,1)=0,0,3 ))

I have tried using

[NAD27_76_NORTHI NG] is the coorinate

=ROUND(([NAD27_76_NORTHI NG]-5148000)*1.0004 40935+48000,IIF (MOD([NAD27_76_NORTHI NG],1)=0,0,3))

[rtilson]

I figure it out by replacing the MOD with INT - MOD(n-d) excel and n MOD d access but it doesn't work so I replaced with n-d*INT(n/d)

=Round(([NAD27_76_NORTHI NG]-5148000)*1.0004 40935+48000,IIf ([NAD27_76_NORTHI NG]-1*Int([NAD27_76_NORTHI NG]/1)=0,0,3))

[NeoPa]

Perhaps if you told us what the problem is we could give some consideration to it. Simply saying it doesn't work is not a great deal to work from ;)