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
>apply Fuzzy calculations using intervals represented by lower and
>upper limits. These limits can not have the same formula.
> 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.
> Tushar Mehta
> 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
>will get each of the 4 answers, one per cell.
>It would be much simpler to enter a single equation in each cell,
>you are using this as the argument of a function.
> > 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]