View original (French)

Insert a formula in footer

amar_7423 Posted messages 29 Status Member -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor 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.

5 answers

  1.
    Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    Hello.

    A formula, no. A sentence, yes.

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
  2. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    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)
    0
  3. amar_7423 Posted messages 29 Status Member
     
    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?
    0
  4. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    "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... 
     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)
    0
  6. amar_7423 Posted messages 29 Status Member
     
    I'm sorry, I'm afraid I won't understand your answer!
    -1