View original (French)

4 hidden cells in one cell

bibi 14 Posted messages 4 Status Member -  
m@rina Posted messages 27590 Registration date   Status Moderator Last intervention   -
Hello,
Can you help me please?
Is it possible to have 4 cells in one?
Let me explain:
When I click on cell X1, 4 cells appear: for example A1-B1-C1-D1 and in the first cell I can fill it in like this:
A1=25€
B1=15€
C1=35€
D1=10€
Total=85€
And when I close these 4 cells, 85€ is displayed in cell X1.

Thank you for your help and your responses.

Configuration: Windows XP / Internet Explorer 8.0 Excel 2007

6 answers

  1. ben
     
    Following your explanations and if I understood you correctly: you need to write in cell X1 the following: =A1+B1+C1+D1, then press the ENTER or OK key, and you will get the result of 85.

    Note: Do not manually enter the Euro symbol in the cells. Only enter the numbers.

    Thank you.
    1
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    No bibi: A cell is one cell, not four!
    What you’re saying sounds like a Japanese cartoon, not like computing...

    Retirement is great! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
    1. m@rina Posted messages 27590 Registration date   Status Moderator Last intervention   11 562
       
      lol !!!
      hello Raymond ! ;))
      0
  3. bibi 14 Posted messages 4 Status Member
     
    Hello
    I can very well not put the € sign, but that's not the problem.
    What I want is that when I click on cell X1, I can enter 4 different things and add them up, for example:
    - food expenses: 50.00
    - car expenses: 25.00
    - clothing expenses: 60.00
    - leisure expenses: 30.00
    What I want is that once I have confirmed, cell X1 displays 165.00
    I don't know if I'm expressing myself properly

    Thank you
    0
  4. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    I repeat to you, bibi: it is not feasible!
    The principle of Excel (and all spreadsheets) is to enter one data point per cell, and then write a formula in another cell that refers to the first ones.
    So, by entering 50 in A1, 25 in B1, 60 in C1, and 30 in D1, you just need to enter the formula =SUM(A1:D1) in X1 to get your result of 165.
    This is lesson No. 1 of the introduction to Excel course.

    -> "Is it possible to have 4 cells in one?"
    Answer = NO!
    -> "When I click on cell X1, 4 cells appear..."
    Answer = For that, you would need to use VBA to write a macro.
    -> "... and when I close these 4 cells, it displays 85€ in cell X1"
    Answer = I have never seen cells being "closed"...
    -------------------------------------------- You just need to follow ben's advice.
    Retirement is nice! Especially in the Antilles... :-)
    ☻ Raymond ♂
    0
  6. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello bibi14

    As Raymond said (warm regards to you), without a macro, the problem is not possible without added intermediate cells

    With a macro, a proposal that is close to what you want

    https://www.cjoint.com/?3KllaxxwupZ

    good continuation
    0
  7. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello everyone,

    and why not just write:
    =50+25+60+30 ???
    Plus, you keep the detail of the input.

    eric

    edit: I just saw that it was the first response.
    Some people really like to complicate their lives...
    Learn to use Excel, and make the most of its already rich capabilities.

    You will never respond to an unsolicited DM...
    Well, that's done.
    0