Gnumeric question

William Muriithi william.muriithi-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org
Thu Nov 20 21:15:55 UTC 2008


Hi Pals,

I am using gnumeric over here and have a quick question. I have 4
columns of numbers. Lets say column A, B, C & D. I want to compare
column A and B.

I do not think Gnumeric has the compare function. Okay, it may be
there but I have not been able to find it. So I defaulted to
subtructing the content of column B from content of column A.

The formula is not working across the rows. For example, I thought I
could put this in the first row of column E.

=A1-B1

Then, if I highlight the whole of column E, I assumed the formula
would ripple all the way done. For example, I would have A2-B2 on the
next row, A3-B3 on third row and so forth. Noop, not working.

Any pointer on a good direction? I did a bit of googling, but nothing
helpful has popped up yet. I am just raising this here just in case
someone may know how to do it off head.

Regards,

William
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists





More information about the Legacy mailing list