Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Aug 4, 2:18 pm, jvc007 wrote:
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(X110,X210),1,0) |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
.... or just =--OR(X11=0,X21=0)
(note that I changed to =, as that was what the OP asked for) -- David Biddulph "Spiky" wrote in message ... Why particularly do you want to use Solver? A formula in Y1 would work. =IF(OR(X110,X210),1,0) On Aug 4, 2:18 pm, jvc007 wrote: 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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
(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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver question | Excel Discussion (Misc queries) | |||
Solver Question | Excel Worksheet Functions | |||
Solver question | Excel Discussion (Misc queries) | |||
Solver Question | Excel Worksheet Functions | |||
Solver question | Excel Worksheet Functions |