Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty Cell writes over full cell
Hi all
What I want to do is this: 1. Column Name 2. Column if there is an appendix for the value, empty, otherwise the Value 3. Column if there is an appendix for the value, value & appendix, otherwise empty. Why do I want to this. Well my employer wants to have all the values on the same level, disregarding an appendix if it exists. I made the Formulas work, but if i do following in the second row: if(appendix="";value;"") 'just short version, don't want to confuse anyone! and in the third row: if(appendix="";"";value & appendix) the 2nd and 3rd Column are both aligned right, so if the 2nd column is empty the 3rd column should write over the 2nd. But it does that only if the Cell is totally empty and not, like in my case, filled with a formula which returns "". Any Help would be appreciated. Kind Regards Carlo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty Cell writes over full cell
Carlo
Can't follow what you are saying. Are you talking about different columns? What is an "appendix for the value"? Provide examples of what you have, then what you want to have. Provide details like: Cell A1 has this. Cell A2 has that. I want cell A3 to have this other. Etc. HTH Otto "Carlo" wrote in message ... Hi all What I want to do is this: 1. Column Name 2. Column if there is an appendix for the value, empty, otherwise the Value 3. Column if there is an appendix for the value, value & appendix, otherwise empty. Why do I want to this. Well my employer wants to have all the values on the same level, disregarding an appendix if it exists. I made the Formulas work, but if i do following in the second row: if(appendix="";value;"") 'just short version, don't want to confuse anyone! and in the third row: if(appendix="";"";value & appendix) the 2nd and 3rd Column are both aligned right, so if the 2nd column is empty the 3rd column should write over the 2nd. But it does that only if the Cell is totally empty and not, like in my case, filled with a formula which returns "". Any Help would be appreciated. Kind Regards Carlo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty Cell writes over full cell
Hi Otto
sorry about the misleading Question. i have 3 columns (a,b,c) column a is a text, b or c is the corresponding value. the corresponding value could be a number 0.00 then it would be in column b or it could be a percent value like 0.00% which should show in column C. The problem, thats why i need to do it that way, is that the "." of every number, eiter with or without the % sign should be directly beneath the upper one. if i put every value in column b it would look like this: A B blblablabl 8.23 basdjieief 2.58% what i want to achieve thou is following: A B C blblablabl 8.23 basdjieief 2.58% (well more or less, it can't be done exactly with spaces) in the second example, the value 2.58% is in column C, column C is only as wide as the percent symbol! The problem is, if i write a formula in cell B2, the major part of the Number in Cell C2 will be cut off and it looks like that A B C blblablabl 8.23 basdjieief % Does anyone knows how i can get Excel to display the whole C2!? Hope this time it's understandable. Thanks in advance Carlo "Otto Moehrbach" wrote: Carlo Can't follow what you are saying. Are you talking about different columns? What is an "appendix for the value"? Provide examples of what you have, then what you want to have. Provide details like: Cell A1 has this. Cell A2 has that. I want cell A3 to have this other. Etc. HTH Otto "Carlo" wrote in message ... Hi all What I want to do is this: 1. Column Name 2. Column if there is an appendix for the value, empty, otherwise the Value 3. Column if there is an appendix for the value, value & appendix, otherwise empty. Why do I want to this. Well my employer wants to have all the values on the same level, disregarding an appendix if it exists. I made the Formulas work, but if i do following in the second row: if(appendix="";value;"") 'just short version, don't want to confuse anyone! and in the third row: if(appendix="";"";value & appendix) the 2nd and 3rd Column are both aligned right, so if the 2nd column is empty the 3rd column should write over the 2nd. But it does that only if the Cell is totally empty and not, like in my case, filled with a formula which returns "". Any Help would be appreciated. Kind Regards Carlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell with value returns that value, empty cell returns zero | Excel Worksheet Functions | |||
Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |