Value dependent calculation??

[XManBG]

Hi, I couldn't find a method to make a calculation in Diadem, which affects only one row in the table.  What I need, is to calculate the value of 2 cells dependent on the value of a third one (<, = or >) and to save the calculated value in a new column.  And this shall continue, until the end of the column is reached.  Can someone help me with the VBA code??  Thanks in advance.

Sincerely yours, Hristo Arnaudov

[Walter_Rick]

Hello Hristo Arnaudov,

You can create a loop over channel 3, check the value with the function ChD and depending on the result you calculate channel 1 or channel 2. But you can use the formula calculater too. And that's much faster than the loop. Please find attached an example.

Greetings
Walter

[XManBG]

🙂 Thanks a lot, the calculator expresion is realy easier to use.