Re: Adding a constraint.

From: "Franz" <fra68ve@xxxxxxxxxx>
Date: Fri, 6 May 2005 10:18:41 +0200

"AhmtDY" <AhmtDY@xxxxxxxxxxxxxxxxxxxxxxxxx>ha scritto nel messaggio
BE99DF76-C55E-4594-8D24-150E3EF349F3@xxxxxxxxxxxxx

> Is it possible to add a constraint that makes a cell cannot be equal
> to any number or any other cell.
> i.e. (A1<>3) or (A1<>A2) or (A1<>A2:A5)

You can try using Data Validation.

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------

.

Follow-Ups:
- Re: Adding a constraint.
  - From: Bob Phillips

References:
- Adding a constraint.
  - From: AhmtDY

Prev by Date: Re: counting values within given interval - countif?
Next by Date: Re: How do I change a template (mall) in Swedish Excel
Previous by thread: Adding a constraint.
Next by thread: Re: Adding a constraint.
Index(es):
- Date
- Thread

Relevant Pages

Re: Using Solver with Linear Constraint(s)
... Each cell needs to progressively grow until reaching 1%. ... of growth of the cells in J4:23 needs to stay constant or linear. ... to the constraint block. ... includes the 1% target has a lower bound for optimality. ...
(microsoft.public.excel)
Re: Solver Constraints
... One option would be to make E7 an "Integer" constraint, ... "Dana DeLouis" wrote in message ... > Solver really doesn't like these types of functions. ... Suppose Solver is varying a cell from 4.1, then 4.2, ...
(microsoft.public.excel.misc)
Re: Solver not working for me
... This is enough to confuse Solver, ... lets use a changing cell whose constraint is "Binary" ... It will take me a little while to understand your workaround but, in the meantime, I first tried replacing all the integer cell references "X" with roundbut that did not help. ...
(microsoft.public.excel.programming)
Re: Solver constraint/Formula
... >> You can specify a formula in the right hand side of the constraint. ... > Were you referring to a constraints directly into Solver? ... > constraints into a cell as you mentioned. ... > I believe with a formula on the rhs of a solver constraint, ...
(microsoft.public.excel.worksheet.functions)
Re: Solver constraint/Formula
... You're correct on the Upper bounds of the constraint. ... Were you referring to a constraints directly into Solver? ... constraints into a cell as you mentioned. ... Because there are no formulas on the rhs, and demand is a constant, Excel ...
(microsoft.public.excel.worksheet.functions)