Plz i need advice for excel mathcad connection

[sm�ller-2]

Hey,

maybe anyone can help me.

During Readexcel of a column i encountered an error.

I have the columns in excel via a when function so that: when(A1=0;"";A1) ----> Need a NaN in mathcad when the column in Excel shows a zero.

THe problem is the vector in mathcad is not NaN it is ""

And when i want to do a  max function mathcad encounters an error.

So i would need a NaN so that i can calculate with the vector something.

Now, how can i manage the function in excel so that in Mathcad the empty cells are regognised as NaN so that i can calculate somthing with it.

I dont know how i can do the function in excel.

Best thx ,

Stefan

[sm�ller-2]

the function when(A1=0;NV();A1) is nto working either 😞

Seems to be that the cell has to be completly empty

[Fred_Kohlhepp]

Doesn't EXCEL recognize NaN?

[Werner_E]

You have to write in Excel the string "NaN"  (in double quotes):

IF(A1=0; "NaN"; A1)  (or WENN(....) in the German version)

Don't be tempted to use Excels NA() as Mathcad won't recognize it.

WE

[Fred_Kohlhepp]

Okay, EXCEL doesn't use NaN as not a number, it's a string.  So we need to have Mathcad check:

[Werner_E]

To Excel The string "NaN" ist just a normal string

Its Mathcad which converts that special string to its NaN automatically

So no extra checking in Mathcad is necessary.

WE

[sm�ller-2]

Bets Thx "NaN" is working 😃

[Werner_E]

Please close your thread by marking them as "answered".