HP Forums

Full Version: use vectors in spreadsheet
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Wondering if anyone can help me.

I have a spreadsheet like this
P1 P2 D
[5,5] [9,8]

I set column D to P1-P2 but it give me 2.
Can I not do vector subtraction in the spreadsheet?
Vector subtraction works, but you will need to press the 'CAS' soft-button in order to enter the '=P1-P2' correctly. (I get a 'syntax error' otherwise)
ok that works.

1 more question on these spread sheets.
If I enter in something in say C1 and then later decide I want to just define something for the entire column C instead, I can't get it to use what I define for the column in C1 as well since I had something in there. I've tried everything I can think of to clear it out but can't get it to clear.

Also the switching in and out of cas seems to be a little flakey. Now it is working without cas but giving a list of the concatenation of everything in columns 1 and 2 in every column 3 when I turn on cas.
I'm not sure I understand the question, but here's what I found.
If there is a formula in a cell (e.g. C1), it remains as it was after the column is set to some value or formula.
If the column is cleared (by going to the col-heading and deleting its contents), the formula in the 'C1' cell is still there.
If the 'C1' cell is cleared while a column is set to something, the 'C1" takes on that object as well.

Hope this helps,
D
Thanks that comment helped me figure out what was going on.

If you click edit and clear it then it stays as empty, but if you just hit the delete key without clicking edit first it will clear and take on the value of the column.

Starting to get the hang of this calculator now.
Reference URL's