4 hidden cells in one cell
bibi 14
Posted messages
4
Status
Membre
-
m@rina Posted messages 27232 Registration date Status Modérateur Last intervention -
m@rina Posted messages 27232 Registration date Status Modérateur 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
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 réponses
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.
Note: Do not manually enter the Euro symbol in the cells. Only enter the numbers.
Thank you.
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
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
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 ♂
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 ♂
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
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
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.
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.