Insert a formula in footer
amar_7423
Posted messages
29
Status
Membre
-
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58551 Registration date Status Contributeur Last intervention -
Hello,
I would like to insert a formula in the Excel footer.
For example, = stop the current list at 37 admitted.
Thank you in advance.
I would like to insert a formula in the Excel footer.
For example, = stop the current list at 37 admitted.
Thank you in advance.
5 réponses
Hello.
A formula, no. A sentence, yes.
--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
A formula, no. A sentence, yes.
--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
In a footer, you cannot put a formula, which is reserved for the cells of the spreadsheet.
In a footer, you can enter the phrase "stopped the present list at 37 admitted," knowing that every time the number of admitted changes, you must manually correct the phrase...
Is my answer more understandable this way?
--
It's good, retirement! Especially in the Antilles...
Raymond (INSA, AFPA)
In a footer, you can enter the phrase "stopped the present list at 37 admitted," knowing that every time the number of admitted changes, you must manually correct the phrase...
Is my answer more understandable this way?
--
It's good, retirement! Especially in the Antilles...
Raymond (INSA, AFPA)
Good evening, Mr. Pentier
I didn't know that "you can't put a formula in a footer."
But I've seen printed Excel sheets where the number of admitted candidates automatically changes at the bottom of the page and not manually.
The formula is: = "Stop this list at " & NB.SI(Rsltt;"Admis") & " admitted candidates."
How is this possible?
I didn't know that "you can't put a formula in a footer."
But I've seen printed Excel sheets where the number of admitted candidates automatically changes at the bottom of the page and not manually.
The formula is: = "Stop this list at " & NB.SI(Rsltt;"Admis") & " admitted candidates."
How is this possible?
"How is this possible?" --> I would really like to know!
I am eagerly and curiously waiting for you to send me such a document, so that I can study it...
--
It's great, retirement! Especially in the Caribbean...
Raymond (INSA, AFPA)
I am eagerly and curiously waiting for you to send me such a document, so that I can study it...
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file (max 15 MB)
3) Scroll down to click on the blue button [Create Cjoint link]
4) After a few seconds, the second page appears, with the link in bold; right-click on it and choose "Copy link"
5) Go back to your discussion on CCM, and in your message, click "Paste".
=>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
There are also:
1) https://mon-partage.fr/
2) https://www.transfernow.net/
--
It's great, retirement! Especially in the Caribbean...
Raymond (INSA, AFPA)