Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default using solver question

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default using solver question

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default using solver question

.... 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default using solver question

(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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver question prspilot Excel Discussion (Misc queries) 3 September 19th 07 10:18 PM
Solver Question Mark Excel Worksheet Functions 0 July 11th 06 10:01 PM
Solver question Mick Excel Discussion (Misc queries) 0 April 21st 06 05:33 PM
Solver Question Greg Toews Excel Worksheet Functions 3 March 20th 06 01:43 PM
Solver question Bill_S Excel Worksheet Functions 1 February 2nd 06 06:38 PM


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"