Here are some problems that our users have asked and received explanations on
Cell E4 contains formula. I would like to highlight it (Cell E4) if it's overridden manually in Excel 2007.
Solved by V. S. in 30 mins
I need help for excel cell, Example : in one cell contains are .[2],255[22],45[89], i want total of [ ] sum of bracket ....
Solved by Z. C. in 24 mins
I WOULD LIKE TO FIND THE DOUBLE QUOTE IN A CELL AND REPLACE IT WITH "DITTO". COLUMN A CONTAINS CHARACTER NAMES. COLUMN B CONTAINS THE ASSOCIATED BOARD GAME.
EXAMPLE CELL A1 CONTANS [ PROFESSOR PLUM ], CELL A2 CONTAINS [ COLONEL MUSTARD ] NOW IN CELL B1 CONTAINS [ CLUEDO ] AND CELL B2 CONTAINS [ "" "" ]. NOW IF I WANT TO REMOVE THE DITTOS IN A NEW COLUMN, E.G. COLUMN C. WHAT FORMULA CAN I USE TO REPLACE THE DITTOS WITH [ CLUEDO ]? THANKS FOR YOUR HELP.
Solved by V. J. in 20 mins
in excel
Each green cell contains exactly the same formula (ie =CellAbove ). How come each one displays a different result?
Solved by Z. D. in 26 mins
i need help with a formula.
Example
cell 1a contains "x"
Cell 1b Contains =sum 2a(5):2c(5) Which equals 10
i want cell 2b to be "if cell 1a contains "x" then cell 2c = # inputed-2
so the end value would be 8
how do i word this as a formula?