B Brian of Basildon Aug 31, 2008 #1 Does anyone know if xl cells can be programmed to perform "what" or "what if", "goto", "if", "then" etc
Does anyone know if xl cells can be programmed to perform "what" or "what if", "goto", "if", "then" etc
M Mike H Aug 31, 2008 #2 Hi, You can almost certainly do that in Excel, probably with a formula (but the goto bit maybe a problem) and if not with a macro. Why not post what you are trying to achieve and I'm sure someone will help. Mike
Hi, You can almost certainly do that in Excel, probably with a formula (but the goto bit maybe a problem) and if not with a macro. Why not post what you are trying to achieve and I'm sure someone will help. Mike
G Gord Dibben Aug 31, 2008 #3 You cannot "format" cells to do anything. You would need formulas in those cells to return results based upon your criteria. In B1 enter =IF(A1="qwerty", "A1 is qwerty","A1 is not qwerty") Which is an if, then,else formula. Speaking of formulas, they can return results only to the cells in which they are written. i.e. a formula can "pull" but it cannot "push" Gord Dibben MS Excel MVP
You cannot "format" cells to do anything. You would need formulas in those cells to return results based upon your criteria. In B1 enter =IF(A1="qwerty", "A1 is qwerty","A1 is not qwerty") Which is an if, then,else formula. Speaking of formulas, they can return results only to the cells in which they are written. i.e. a formula can "pull" but it cannot "push" Gord Dibben MS Excel MVP
