Formule access

[youba14]

Bonjour à toutes et à tous




Je me tourne vers vous pour solliciter votre savoir faire pour m'aider à résoudre un problème qui me dépasse. Grace au net je suis arrivé à me débrouiller pas mal en excel et Access et en ce moment j'ai fait une fiche de paie en excel que j'aimerais refaire en Access mais je suis bloqué au niveau des formule. Je me tourne vers vous donc pour solliciter votre aide. Ci-joint mon fichier excel et ci-dessous les formule excel que j'aimerais reproduire sous Access.

TRANSLATION:
I turn to you to seek your expertise to help me solve a problem that is beyond me. Thanks to the net I came to get by pretty in Excel and Access, and this time I made a payslip in excel that I would like to repeat in Access, but I'm stuck at the formula. I therefore turn to you to ask for your help. Attached my excel and below the excel formula that I would reproduce in Access.

formule excel
=SI(E31>=60000;60000*0%+SI(E31>=150000;90000*15%+S I(E31>=270000;120000*25%+(E31-270000)*40%;(E31-150000)*25%);(E31-60000)*15%);E31*0%)


=SI(SOMME(F16:F26)>70000;700*2;SOMME(F16:F26)*2%)


=(E11*0,4)+E11


=SOMME(F11:F14)


Merci à toute et tous

[June7]

In the future, please post in English.

No Excel file attached.

I presume SOMME means SUM. There is no intrinsic function to sum a range of fields.

=[field11] + [field12] + [field13] + [field14]

=[field11] * 0.4 + [field11]

What function is SI - IF? Functions to use in Access are IIf, Switch, Choose. Refer to Access Help for details.

[youba14]

Thank you June7 for your reply. I am from Mauritania and my english is not very good. here is my need in english
Hello to you all




I turn to you to seek your expertise to help me solve a problem that is beyond me. Thanks to the net I came to get by pretty in Excel and Access, and this time I made a payslip in excel that I would like to repeat in Access, but I'm stuck at the formula. I therefore turn to you to ask for your help. Attached my excel and below the excel formula that I would reproduce in Access.



excel formula

[June7]

I already edited you post to show the Google translation.

See suggestions in my previous post.

[youba14]

Thank you for your advices and support

[youba14]

I want to attach a file but could not. Can you please advice

[June7]

Why couldn't you attach? What did you try? Click the Go Advanced button below post editor window. Attachment manager is below the advanced post editor.

Access Help has guidelines for building expressions. If you don't understand this basic Access functionality, suggest you get an introductory book.