1 страниц (4 вхождений)
Matrix Evaluation - null values - Сообщения
#1 Опубликовано: 01.10.2010 16:00:09
Hi-
I have a quick question concerning matrices and null values.
On my worksheet, I am using a matrix to evaluate a series of formulas based on constant value inputs. There are times when 1 or 2 of the input values need to be zero. unfortunately when that happens, the matrix won't calculate due to some of the cells being a 'null value. is there a way to setup the matrix or data so that when a 'null value is present it won't fail?
i can send you the worksheet if it would be clearer.
thanks
steve
I have a quick question concerning matrices and null values.
On my worksheet, I am using a matrix to evaluate a series of formulas based on constant value inputs. There are times when 1 or 2 of the input values need to be zero. unfortunately when that happens, the matrix won't calculate due to some of the cells being a 'null value. is there a way to setup the matrix or data so that when a 'null value is present it won't fail?
i can send you the worksheet if it would be clearer.
thanks
steve
#2 Опубликовано: 01.10.2010 18:08:29
Hello. Yes, please send me a file. Then I could help you.
Regards.
Regards.
#3 Опубликовано: 02.10.2010 16:19:16
Hello sttrebo.
Thank you, I've received the file and now I see what is question about in details. Actually SMath Studio has no any built-in option to ignore "Division by zero" error and to put zero number into the answer. As you have already done I'm only thinking to use if(..) statement to emulate this functionality.
Best regards.
Thank you, I've received the file and now I see what is question about in details. Actually SMath Studio has no any built-in option to ignore "Division by zero" error and to put zero number into the answer. As you have already done I'm only thinking to use if(..) statement to emulate this functionality.
Best regards.
1 страниц (4 вхождений)
-
Новые сообщения
-
Нет новых сообщений