Excel formula in Access

[youba14]

Hello, please help. How can I create these excel formula under Access
=((C13*3+D13+E13*2+F13*3)/9)*B13
=(G13+G14+G15+G16+G17+G18+G19+G20+G21+G22)/23





Here what I try ([MInterro]*3)+([Compo1]+[Compo2]*2)+([Compo3]*3)/9*[Coef]

Thank you

[JoeM]

Where are you trying to add this formula?
In a Calculated Field in a Query?

The plus sign, parentheses, and multiplication all work the same in Access as they do in Excel.
You should just be able to replace each Excel cell reference with your Access field reference to build a valid function that does the same thing.

[youba14]

in a table calculated field

[ssanfu]

I do not use calculated fields in tables. I think it is a bad thing to do - calculated fields in tables have issues (from what I have read).

Calculated fields in queries is the way to go.


Also, be aware that this formula
([MInterro]*3)+([Compo1]+[Compo2]*2)+([Compo3]*3)/9*[Coef]

is NOT the same as
=((C13*3+D13+E13*2+F13*3)/9 ) *B13

Follow the parentheses ....

[JoeM]

I do not use calculated fields in tables. I think it is a bad thing to do - calculated fields in tables have issues (from what I have read).

Calculated fields in queries is the way to go.

I agree wholeheartedly!

See here for some reasons why: http://allenbrowne.com/casu-14.html

[youba14]

thanks to you all. I find the solution following all your advices, here the formula I use : ([MInterro]*3+[Compo1]+[Compo2]*2+[Compo3]*3)/9*[Coef]