View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
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)