using solver question

J

jvc007

How do you perform and inclusive or test using solver. I need Y1 to equal 1
if x11 or x21 is greater than o and Y1 to equal zero if both x11 and x21
equal zero
using solver: if x11 or x21 >= 0 then y1=1 otherwise y1=0
 
S

Spiky

How do you perform and inclusive or test using solver. I need Y1 to equal 1
if x11 or x21 is greater than o and Y1 to equal zero if both x11 and x21
equal zero
using solver: if x11 or x21 >= 0 then y1=1 otherwise y1=0

Why particularly do you want to use Solver? A formula in Y1 would
work.
=IF(OR(X11>0,X21>0),1,0)
 
D

David Biddulph

.... or just =--OR(X11>=0,X21>=0)

(note that I changed > to >=, as that was what the OP asked for)
 
S

Spiky

(note that I changed > to >=, as that was what the OP asked for)

Well, the written part says one thing, and the last line says
something different. I looked at that a bit before posting and decided
no "=" was appropriate, but the OP will have to figure it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a Solver question 1
a solver problem 1
Creating a function to auto hide rows 1
Help with a formula 12
varying a cell and seeing the outcome 2
decision Box Y 2
VBA looping 1
Summing a range of cells with criteria 7

Top