I am looking for a way to represent Fuzzy numbers and calculations

using excel or Matlab.

>Subject: Re: Interval Calculation in EXCEL

>Thanks for the explanation, but what I am really looking for is how

to

>apply Fuzzy calculations using intervals represented by lower and

>upper limits. These limits can not have the same formula.

>Regards,

> As Jerry Lewis indicated, just array-enter the formula in the

> appropriate number of cells. It is up to you to interpret the contents

> of those cells as a 'joint pair.' Of course, since the cells contain an

> array-formula, one cannot be changed without the other and so, to that

> extent, the two cells will appear as one pair.

> --

> Regards,

> Tushar Mehta

> www.tushar-mehta.com

> Microsoft MVP -- Excel

> Subject: Re: Interval Calculation in EXCEL

>2 is the result of the first of 4 divisions (14/7). To see all 4

>results, you have to select 4 adjacent columns in a row, type the

>formula and use Ctrl-Shift-Enter to array enter the formula. Then

you

>will get each of the 4 answers, one per cell.

>It would be much simpler to enter a single equation in each cell,

unless

>you are using this as the argument of a function.

>Jerry

> > Is there any excel functions, programs or solvers that deal with intervals

> > Example:

> > [3,4]+[2,5]=[7,9]

> > [3,4]-[5,7]=[-4,-1]

> > [3,4]*[5,7]=[15,28]

> > [3,4]/[5,7]=[3/7,4/5]