Hi,

This forum doesn't seem to support the tinspire cx cas, but it was the closest thing to where i could hope to find an answer for my problem, maybe someone here can help me.

What i want to do is actually quite simple, i want to use certain elements of a spreadsheet in a program in the form of:

If isempty cells(a1) then
cells(c2)=cells(b4)*cells(b4)
elseif
someothercode
elseif
yetadifferentcode
else
disp "make sure all neccessary fields are filled"
endif

I need those checks since the value i want to calculate can be calculated with different formulas and depending on the case some initial values are given or not and depending on the given values, different formulas have to be used.

I tried typing the if statements in the cells in the spreadsheet directly like you can do with excel, but that didn't work. Is there a way to link a program with a spreadsheet, or is that function missing?

Thank you very much for your time in advance