By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,538 Members | 875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,538 IT Pros & Developers. It's quick & easy.

excel formula to access expression

P: 2
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.000440935+48000,IF(MOD(A2,1)=0,0,3))

I have tried using

[NAD27_76_NORTHING] is the coorinate

=ROUND(([NAD27_76_NORTHING]-5148000)*1.000440935+48000,IIF(MOD([NAD27_76_NORTHING],1)=0,0,3))
Attached Images
File Type: jpg access.jpg (27.3 KB, 2962 views)
Nov 25 '09 #1
Share this Question
Share on Google+
2 Replies


P: 2
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_NORTHING]-5148000)*1.000440935+48000,IIf([NAD27_76_NORTHING]-1*Int([NAD27_76_NORTHING]/1)=0,0,3))
Nov 25 '09 #2

NeoPa
Expert Mod 15k+
P: 31,662
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 ;)
Nov 29 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.