Skip to main content
S
Somkung1-Visitor
1-Visitor
April 19, 2020
Question

Command not be considered when numbering i=j

  • April 19, 2020
  • 1 reply
  • 7063 views
I have just learned to use programs to write calculations.
and I have 3 questions

1.How can i write command to sum value in table from column A to column B
2.How can i write Command to not be considered when numbering i=j
3.How can i choose the lowest value from table with numbering

Thankyou
Somkung

1 reply

W
Werner_E25-Diamond I
25-Diamond I
April 19, 2020

The attached sheet should help

S
Somkung1-VisitorAuthor
1-Visitor
April 20, 2020

thank you for the answer.😀

 

But for this "not be considered when numbering i=j"

 

I mean i would like to skip calculate when i = j only (Calculcate by Given i=/= j )

 

i have more some question

 

Please see my new Mathcad again

W
Werner_E25-Diamond I
25-Diamond I
April 20, 2020

You have a calculation using indices i and j and so you create a 2-dimensional array.
You must decide which value you would like to see in this array at the diagoinal, where i=j.

In my examples I had chosen NaN ("Not a Nuber") as 'value' but you can change it for anything else. You can use a reals number (e.g. a zero) or even a text string. But you can't leave it empty!

 

Terms & ConditionsAccessibility statement