using the google spreadsheets

[compactstu]

First of all thanks for those advising me. Second I suppose that the
google spreadsheets are simular to exell. If not please say so.
Third. ...Anyone can tell me the formula for subtracting 1 cell from
another?
I thought It would be something like MIN=(A6-B6) but i can only find
the sum formula what adds up two values.

Thanks.

 

[Harlan Grove]

First of all thanks for those advising me. Second I suppose that the
google spreadsheets are simular to exell. If not please say so.

Why would you expect Excel users to know how any other spreadsheet works?
Many do, but they probably know OLDER spreadsheets than Excel rather than
newer ones.

Third. ...Anyone can tell me the formula for subtracting 1 cell from
another?

....

Same as in Excel (or nearly any other spreadsheet)

=A6-B6

returns the value of A6 minus the value of B6.

 

[Gord Dibben]

I know nothing of google spreadsheets but in Excel.................

23 in A1 45 in B1

In C1 enter =B1-A1


Gord Dibben MS Excel MVP

 

[ilia]

Just tried Google Spreadsheets, it works exactly this way.

 

[compactstu]

hi Harlan,

thanks for your help.

Stuart

Why would you expect Excel users to know how any other spreadsheet works?
Many do, but they probably know OLDER spreadsheets than Excel rather than
newer ones.


...

Same as in Excel (or nearly any other spreadsheet)

=A6-B6

returns the value of A6 minus the value of B6.

 

[compactstu]

Just tried Google Spreadsheets, it works exactly this way.








- Show quoted text -

Thanks Ilia,

Stu

 

[compactstu]

I know nothing of google spreadsheets but in Excel.................

23 in A1 45 in B1

In C1 enter =B1-A1

Gord Dibben MS Excel MVP






- Show quoted text -

Thanks for the reply,

Stu

 

[compactstu]

Just tried Google Spreadsheets, it works exactly this way.








- Show quoted text -

Hi Ilia,

I have tried to do it but something is going wrong

If cell A9 value = 4
If cell B9 value = 2

I want the value in a formula in cell C9

Than is should be =Sum(A9-B9)

Well it doesn't do anything so where I am going wrong??

 

[Susan]

i did it both ways

=B4-C4
and
=sum(B4:C4)

and they both worked for me. although the one with "sum" took a
minute to calculate.
i don't know enough about google spreadsheets to say why yours isn't
working.

susan

 

[compactstu]

I finally got it....Thanks

SW

 

[Sandy Mann]

=sum(B4:C4)

and they both worked for me. although the one with "sum" took a
minute to calculate.

Do you *really* mean one minute?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[=?iso-8859-1?B?VG9taSBI5HPk?=]

First of all thanks for those advising me. Second I suppose that the
googlespreadsheets are simular to exell. If not please say so.
Third. ...Anyone can tell me the formula for subtracting 1 cell from
another?
I thought It would be something like MIN=(A6-B6) but i can only find
the sum formula what adds up two values.

Google Docs & Spreadsheets forum:

http://groups.google.com/group/GoogleDocsSpreadsheets

Newsgroup about Google:

http://groups.google.com/group/alt.comp.google/

 

[Susan]

Sandy -
no, not an actual 60 seconds, but i'm on broadband & no way was it
instantaneous - maybe 30 seconds. i was sitting there waiting for it,
and was thinking it wasn't going to work at all.
i had never looked @ google spreadsheets before, but i was pretty
disappointed in the product.

susan

 

[Harlan Grove]

i had never looked @ google spreadsheets before, but i was pretty
disappointed in the product.

....

It's still a toy, and it probably will always be.

ThinkFree seems to be the solidest online spreadsheet at the moment, though
EditGrid may be catching up fast.