View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How to use Excel to solve inequality formula?

Pick an extremely tiny number for x1 thru x9 (just above zero).

set x10=c-x1-x2-x3-x4-x5-x6-x7-x8-x9
--
Gary''s Student - gsnu200736


" wrote:

Hi,

I need to know how to use Excel to solve the following formula.

x1+x2+x3+...+x10 = c. c is constant
while
0<x1<c
0<x2<c
....
0<x10<c

Does anyone how to use Excel to get one of the solutions
automatically?


Thank you.